Re: Stored procedure name

use dbms_utility.format_call_stack to get the current call stack. looks like below:

• PL/SQL Call Stack ----- object line object handle number name 81a2f938 306 package body SMS.PKG_ERROR 8175421c 25 package body SMS.PKG_SMS_SV 812f3c08 236 package body SMS.PKG_SHIP_UPDATE 810b63ec 192 package body SMS.PKG_SHIP_INTERFACE 808de934 1 anonymous block 808de934 1 anonymous block

lines are terminated with chr(10). write yourself a procedure to extract the info that you want. I have a general error-handling package that uses this to extract the name of the module that fell over. one limitation is that when you execute packaged procedures, only the package name shows, not the procedure name. still, you do get a line number which you could use to get the procedure name from user_source, and it's heaps easier than trying to manually maintain a call stack yourself.

for some reason, triggers show up twice for each call in 7.3 - I don't know why.

-- 
Andrew - Wizzard

barnetaj_at_bp.com

Timothy McKeon <tim.mckeon_at_mci.com> wrote in article
<34FD8FF8.EEE66627_at_mci.com>...


> From within a stored procedure is there a way to determine the name of

> stored procedure you

> are currently in?  I couldn't find it in any of the DBMS packages.

> 

> Any help would be appreciated.

> 

> 

> 

> Tim

> 

>