Hi,
May someone support me, please?
I have this version Data Base:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
PL/SQL Release 12.1.0.2.0
How can I list the procedures and their tables used inside one package.
I found diferents tables like:
-- package name , procedure name
select * from all_procedures
where owner = 'HR'
and object_type = 'PACKAGE';
select * from dba_dependencies
where owner = 'HR';
select * from dba_procedures
where 1=1
and object_type = 'PACKAGE'
and owner = 'HR'
;
I see the package name, procedures, even tables but I don't know which table belong to procedure.
Example,
I have paq_test package, how can I see that this, have inside prc_get_id, and uses employees table
create or replace package body paq_test
is
procedure prc_get_id
is
begin
SELECT employee_id into v_id
from employees
where employee_id = 10;
ENd;
end paq_test;
Thank you so much.
best Regards
Mensaje editado por: simon87