Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Accessing Unique Session ID

Accessing Unique Session ID

From: Mary <mdellamalva_at_cetec.com>
Date: 2000/06/12
Message-ID: <8i3r6c$ejg@journal.concentric.net>#1/1

Hello Everyone,

I need to access the unique session id for each and every session that connects to my Oracle (7.3.4) Database at the time of connection. I have been trying to tap into the DBMS_Session function: unique_session_id, however it does not appear to have the pragma restrict_references set. I keep getting the following ORA Error: ORA-06571: Function UNIQUE_SESSION_ID does not guarantee not to update database.

Does anyone know how to set the pragma restrict_references for this built in function external to the function itself? Or, is there another way of accessing the unique sessionid for a specific connection without referencing the userid which will remain the same for multiple connections?

Any help would be appreciated

Mary
mdellamalva_at_cetec.com Received on Mon Jun 12 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US