Subject Re: [firebird-support] RDB$GET_CONTEXT()
Author Geoff Worboys
lcampbell lcampbell@... [firebird-support] wrote:
> Actually, there's nothing in the UDFs section of my
> DBWorkbench... on any of my DBs. Is there something missing
> from my installation?

Check the ODS version of the databases - it should be 11.2
for FB v2.5 databases. (Might you have multiple versions of
Firebird installed and inadvertently created something from
a different version? Or be looking at databases that have
not yet been properly upgraded?)

Note also that namespaces and names are all case-sensitive
with FB context variables. So you need:
select rdb$get_context('SYSTEM', 'SESSION_ID') from rdb$database;
not that that is the reason for your reported error.

Geoff Worboys
Telesis Computing Pty Ltd