Re: Name of procedure that called another one

In article <9ljrcn$bdn$1_at_bagan.srce.hr>, Vucko says...
>
> 10 different procedures call ProcedureX. Is there any
>way to find out which procedure (with its parameters) called ProcedureX?
>
> ProcedureN(par1, ..., parm) (N=1..10)
> begin
> blah;
> ProcedureX(par1, ..., parn);
> end;
>
> ProcedureX(par1, ..., parn);
> begin
> blah;
> Here I want to know which procedure called this one. How to find
>out that?
> end;
>
> Tnx.

see
http://osi.oracle.com/~tkyte/who_called_me/index.html ....

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp