dynamobi/dynamobi — Issue #113: [LDB-209] New UDF to get current session ID
Author: dynamobi-build
Created: 2011-12-30 02:14:10+00:00
State: open
Labels: Applib, LDB

[reporter="ngoodman", created="Fri, 29 Jan 2010 13:45:58 -0500 (GMT-05:00)"]
select * from values (applib.current_session_id());

returns integer, with the current session ID. Useful for joining to sys_root.DBA_SESSIONS.

An alternative is to add an ID / VALUE to user_session_parameters view but since it can't be set using "alter session" that may not make since.