Re: Getting program name in PL/SQL procedure?

Malcolm Dunnett wrote:
> I'd like to be able to get the program name that
> called a PL/SQL procedure ( the information that
> Enterprise Manager shows under the "Program"
> column of the sessions display ).
>
> I would have thought it was a SYS_CONTEXT
> item but I can't find a code that produces this
> information.
>
> Can anyone enlighten me on how to retrieve this
> information?

This capability is documented in Morgan's Library at www.psoug.org. Look at the OWA_UTIL.WHO_CALLED_ME demo.

What it is using is DBMS_UTILITY.FORMAT_CALL_STACK but this is far simpler to implement.

-- 
Daniel Morgan
Puget Sound Oracle Users Group