Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Can a PL/SQL procedure or function tell its own name ?
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
![]() |
![]() |