Re: Identifying the executing PL/SQL procedure when an Oracle error occurs

I should have been more specific. Is there any way to get the procedure (and possibly enclosing package) name without assigning it manually like Daniel suggested (which is what I'm already doing)? Is that information already kept dynamically in a table which Oracle automatically maintains?

-Ken Ho
hoke_at_gse.harvard.edu

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3CAB718A.30E08940_at_exesolutions.com>...
> Assign the proc name to a variable in the variable definitions:
>
> ThisProc VARCHAR2(30) := 'Standalone_Proc';
>
> Daniel Morgan
>
>
>
> Ken Ho wrote:
>
> > Is there a straightforward way to identify the executing PL/SQL
> > procedure when an Oracle error occurs, i.e.,
> > ENCLOSING_PKG.EXECUTING_PROCEDURE (or simply EXECUTING_STANDALONE_PROC
> > if it were a standalone procedure which caused the Oracle error)?
> >
> > -Ken Ho
> > hoke_at_gse.harvard.edu
Received on Thu Apr 04 2002 - 08:51:42 CST