Re: Determine the session of a user who calls a proc accross a DBLink?

  • From: "Engler, Eric" <Eric.Engler@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jul 2004 17:07:30 -0400

>>I've got a logging procedure that runs in our main database instance.
>>We have a lot of smaller instances that connect to the main instance
>>...
>>I'd like the "add_event" procedure to be able to determine
>>which DB session called him.
=20
>What version of DB ??

I'm on 9i (9.2.0.5.0).

Eric
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: