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