RE: How can i receive name of the running procedure

Take a look at DBMS_UTILITY.FORMAT_CALL_STACK.  You can parse out the caller from the return value.  Here's a short example of an anonymous block:

DECLARE stack_info VARCHAR2(4096);

BEGIN stack_info:=DBMS_UTILITY.FORMAT_CALL_STACK;

DBMS_OUTPUT.PUT_LINE(stack_info);

END;

• PL/SQL Call Stack -----

  object      line  object

  handle    number  name

c1b59734         4  anonymous block

HTH Tony Aponte

-----Original Message-----

From: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se]

Sent: Friday, January 25, 2002 1:07 PM

To: Multiple recipients of list ORACLE-L

Subject: How can i receive name of the running procedure

Hallo,

How can I select the name of the procedure, which is running.?

I mean I am running a procedure and I want the name of the pocedure to be inserted in a table.

 Please help me with a simple pl/sql script on this.

Thanks in advance

Roland S

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: 



  INET: Roland.Skoldblom_at_ica.se



Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).