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!

Identifing DMLs on specific database objects in procedure.

711049Feb 1 2010 — edited Feb 1 2010
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2010
Added on Feb 1 2010
3 comments
552 views