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 -> Can a PL/SQL procedure or function tell its own name ?

Can a PL/SQL procedure or function tell its own name ?

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 16 Nov 2007 14:28:09 -0500
Message-ID: <13jrrqc13li1bff@corp.supernews.com>


Hello

I'm looking for a way to tell, in a PL/SQL named procedure or function, the name of the procedure or function.

For example

CREATE or REPLACE PROCEDURE XXX as
BEGIN
dbms_output.put_line('this is procedure XXX running'); END;
/

Is there a special variable like those ora_something that exist, which would contain the name of the executing procedure ? Or some other way to do this ?

Thanks !

Syltrem
Oracle 10gr2 on OpenVMS Received on Fri Nov 16 2007 - 13:28:09 CST

Original text of this message

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