On 12/12/2014 12:23 PM, 'Martijn Tonies (Upscene Productions)'
[email protected] [firebird-support] wrote:
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.
