Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting program name in PL/SQL procedure?

Re: Getting program name in PL/SQL procedure?

From: cc <chris.colclough_at_nospam.jhuapl.edu>
Date: Thu, 5 Oct 2006 12:10:59 -0400
Message-ID: <eg3aqm$h8d$1@aplcore.jhuapl.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US