Identifing DMLs on specific database objects in procedure.
711049Feb 1 2010 — edited Feb 1 2010Hi,
I'm looking for oracle dictionary views or oracle procedure to identify which DML operations exist in a specific stored procedure. For example,
create or replace procedure test_proc as
i integer;
begin
select count(*) into i from test_table;
end;
I want to identify which DML operation exist on which database object in this test_proc procedure. The answer should be such as, TEST_TABLE ------> SELECT.
How I can solve this problem?
Thanks.