RE: how to tell who the caller of a procedure is
Date: Wed, 30 Jan 2008 12:50:24 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A901E2EFEE@usahm208.amer.corp.eds.com>
I used to have this code but cannot find it; however, I did find where I had posted on this topic in the past. The link to Tom Kyte's code no longer works but you should be able to search at http://asktom.oracle.com for who_called_me to get an example.
http://groups.google.com/group/comp.databases.oracle.server/browse_frm/t hread/f6c3bc8a77054da1/e2bcb3cf57da0a1e?hl=en&lnk=st&q=#e2bcb3cf57da0a1e
http://groups.google.com/group/comp.databases.oracle.misc/browse_frm/thr ead/6d648b38211d8410/f6894df20f7f46b8?hl=en&lnk=st&q=#f6894df20f7f46b8
- Mark D Powell -- Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 30 2008 - 11:50:24 CST