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

Home -> Community -> Mailing Lists -> Oracle-L -> Determine the session of a user who calls a proc accross a DBLink?

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

From: Engler, Eric <Eric.Engler_at_zcsterling.com>
Date: Tue, 20 Jul 2004 14:59:48 -0400
Message-ID: <583E01FC7F0C994EAA2CC39253B4CDF002A8A7AE@atlexc01.zcs.corp>


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=20 instance to run certain procedures/functions.

When the logging procedure is called from another instance, I want to log the message he sends me (along with sysdate, etc), but I also want to log the name of the instance where he was=20 running when he called me.

The obvious answer is to have him fetch the name of his own instance and pass it to me. But that's more invasive. I'd like him to be able to call me with only one call like this:

  add_event_at_maindb('bad part specified','WARN');

And I'd like the "add_event" procedure to be able to determine which DB session called him.

Does anyone know if this is possible?

Thanks,
Eric



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Jul 20 2004 - 13:56:30 CDT

Original text of this message

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