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: Identifying the executing PL/SQL procedure when an Oracle error occurs

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

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 03 Apr 2002 21:18:02 GMT
Message-ID: <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_at_gse.harvard.edu

Received on Wed Apr 03 2002 - 15:18:02 CST












Original text of this message













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