System variable for the current procedure/function [message #347845] |
Sun, 14 September 2008 09:32 |
beetel
Messages: 96 Registered: April 2007
|
Member |
|
|
Hi,
Is there a system variable to know the current procedure? For instance, if I am running inside procedure MyProc. And I would like to display the current procedure, can I have something like:
dbms_output.put_line(sys_proc);
where sys_proc is a system-defined variable (like 'user','sysdate')? Else, I would have to hard-code it as:
dbms_output.put_line('MyProc');
Thanks in advance.
|
|
|
|
|
|
|
|