Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get line number of the package procedure that called from another package procedure

ronald_2017May 21 2022

Hello All,

Is there a data dictionary view that show which package procedure is called from which line in the same package with another procedure?

For example p1 is called inside p2. I want to learn the line number of the invoked procedure.

Or is there any dictionary view that show package procedure start and end line number?

create package pkg1
is

    procedure p1;
    procedure p2;

end;


create package body pkg1
is


    procedure p1
    is
    begin
        dbms_output.put_line('p1');
    end;


    procedure p2
    is
    begin
        p1;
    end;


end;

Thanks

Comments
Post Details
Added on May 21 2022
9 comments
1,945 views