Subject Re: [firebird-support] RDB$GET_CONTEXT()
Author Martijn Tonies (Upscene Productions)
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

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!