Subject | Re: [firebird-support] RDB$GET_CONTEXT() |
---|---|
Author | lcampbell |
Post date | 2014-12-12T21:10:30Z |
***************************************************************Hello Lane,
>I've got a V2.5 DB, and using DB Workbench.
Good. ;)
>Based on a hint from the Firebird Book, I tried the following query, hoping
>to get a Session_ID:
>'select rdb$get_context('system', 'session_id') from rdb$database;'
>
>I got back a "Dynamic SQL error -804 Function unknown RDB$GET_CONTEXT"
>message. What am I doing wrong?
Well, I'm getting:
Invalid namespace name system passed to RDB$GET_CONTEXT
But at least the function works.
In Database Workbench, if you expand the "UDFs" node after establishing a
database connection, is RDB$GET_CONTEXT listed?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Actually, there's nothing in the UDFs section of my DBWorkbench... on any of my DBs. Is there something missing from my installation?
Lane C.