RE: how to tell who the caller of a procedure is
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <oxnard@xxxxxxxxxxxxxxx>, "Post to FreeList Oracle-L" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 30 Jan 2008 12:07:28 -0500
Ox,
Is the caller always the same Oracle user?
If so, you can use dbms_application_info.set_action('INSERTING');
package in the calling procudure and then interrogate the context. But
it would be easier to simply pass in the caller id.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Oxnard Montalvo
Sent: Wednesday, January 30, 2008 12:02 PM
To: Post to FreeList Oracle-L
Subject: how to tell who the caller of a procedure is
Oracle ver 10.2.0.3.0
I have a procedure which is called from one of four functions. Other
than simply passing the name in as a varchar is there a way to have the
procedure known the name. In my procedure I have one of four things to
do based on who the calling function is.
Thanks
Ox
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
