Subject Re: [firebird-support] RDB$GET_CONTEXT()
Author lcampbell

On 12/12/2014 12:23 PM, 'Martijn Tonies (Upscene Productions)' m.tonies@... [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

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.