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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: own session's SID

Re: own session's SID

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 15 Oct 2004 21:53:14 +0100
Message-ID: <00a001c4b2f8$fd7c1ea0$6702a8c0@Primary>

Or you could create a logon trigger that acquired the value and stuffed it into a context so that the user could use a call to sys_context('your_system_context','sid').

Probably more efficient for the user to
call sys_context than it would be to call a home-grown pl/sql function. (Not guaranteed, of course, as sys_context() is resolved in pl/sql through a select from dual).

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th

No, it's by no means a 10g thing. It is unsupported/undocumented stuff. It's like using an 18-wheeler to drive from home to a grocery shop and back. It works, but..... On top of that, you probably wouldn't want to grant execute on DBMS_SUPPORT to public. In other works, DBMS_SUPPORT is not an answer. Create function as the user system, create public synonym and grant execute on the function to public. When oracle doesn't want to do it for you, you have to take matters in your own hands.

--
Mladen Gogala
A & E TV Network
Ext. 1216



--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 15 2004 - 15:50:44 CDT

Original text of this message

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