Re: Determining your own session ID

Use dbms_pipe.unique_session_name to identify a unique Oracle session.

  function unique_session_name return varchar2;

• Get a name that is unique among all sessions currently connected
• to this database. Multiple calls to this routine from the same
• session will always return the same value.
• Return value:
• A unique name. The returned name can be up to 30 bytes. --

Jez. Received on Wed Apr 30 1997 - 00:00:00 CDT