Skip to content
January 21, 2013 / doganay

How to find the name of calling procedure or package?

create or replace procedure p0 as
begin
 dbms_output.put_line(dbms_utility.format_call_stack);
end;
/

create or replace p1 as
 p0;
end;
/

SQL> set serveroutput on

SQL> exec p1
----- PL/SQL Call Stack -----
object line object
handle number
name
0x9e714cf0 3 procedure MUSTAFAD.P0
0x9e71e1d0 3 procedure
MUSTAFAD.P1
0x9e5dfab0 1 anonymous block
PL/SQL completed successfully.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: