Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: hoke@gse.harvard.edu (Ken Ho)
Newsgroups: comp.databases.oracle.server
Subject: Re: Identifying the executing PL/SQL procedure when an Oracle error  occurs
Date: 4 Apr 2002 06:51:42 -0800
Organization: http://groups.google.com/
Lines: 27
Message-ID: <88f8c6ea.0204040651.1ecb64df@posting.google.com>
References: <88f8c6ea.0204031248.59eec152@posting.google.com> <3CAB718A.30E08940@exesolutions.com>
NNTP-Posting-Host: 128.103.178.91
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1017931902 31625 127.0.0.1 (4 Apr 2002 14:51:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2002 14:51:42 GMT
Xref: easynews comp.databases.oracle.server:142031
X-Received-Date: Thu, 04 Apr 2002 07:49:30 MST (news.easynews.com)

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@gse.harvard.edu

damorgan <damorgan@exesolutions.com> wrote in message news:<3CAB718A.30E08940@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@gse.harvard.edu