Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting program name in PL/SQL procedure?
Try dbms_utility.format_call_stack
"Malcolm Dunnett" <nothome_at_spammers.are.scum> wrote in message
news:GSi1Tw4b3aef_at_malvm9.mala.bc.ca...
>
> 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?
Received on Thu Oct 05 2006 - 11:10:59 CDT
![]() |
![]() |