Fw: how to tell who the caller of a procedure is

Ox

If you just want to know which procedure/function called the procedure, you 
want to read the stack trace from DBMS_UTILITY.FORMAT_CALL_STACK.

See Tom Kyte's widely copied "who called me" at 
http://asktom.oracle.com/tkyte/who_called_me.

Regards Nigel

----- Original Message ----
From: Oxnard Montalvo <oxnard@xxxxxxxxxxxxxxx>
To: Post to FreeList Oracle-L <Oracle-L@xxxxxxxxxxxxx>
Sent: Wednesday, January 30, 2008 5:01:53 PM
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

Other related posts: