Name of currently executiong procedure/Function?

[Bimalaggarwal]

Is there a possibility to find out the name of the cuurrently executing packaged function/procedure ?
I wish to make the exception handler in my sources generic, and not hard-code the names of the procedures/functions in it.
Perhaps, there exists some Oracle utilities to do so. Please help.

 

[magvivek]

Tom Kyte has the perfect solution

http://asktom.oracle.com/~tkyte/who_called_me/index.html

 

[zephan]

Hi Magviv,
Nice this who_am_i
Has tom the solution for getting the name of calling procedure, function, program, something like from_where_i_come ?
Best Regards

 

[zephan]

Sorry, who_called_me is under the same link. You have to download who_am_i and who_called_me and install them on your oracle database.
Thanks