Parse

Thanks
gs79Asked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
you can search for object dependencies with

select * from dba_dependencies where referenced_name = 'UTL_MAIL'

or, if you want to read the code

select * from dba_source where upper(text)  like '%UTL_MAIL%'
0
 
awking00Connect With a Mentor Commented:
Something along the following lines might do it -
declare
v_sql varchar2(255);
v_name varchar2(30);
begin
for o in
(select distinct object_name name
 from dba_objects
 where object_type in
 ('FUNCTION','PROCEDURE','PACKAGE BODY')
 and status = 'VALID'
)
loop
v_sql := 'select '||o.name||' from da_source where text like ''%utl_smpt%'' ';
execute immediate v_sql into v_name;
dbms_output.put_line(v_name);
end loop;
end;
/
You will probably need to add some other filters to the select statement to eliminate unwanted or unnecessary objects (e.g where owner = 'SYSTEM').
0
 
awking00Commented:
Typo - da_source should be dba_source
0
 
gs79Author Commented:
ok..i had figured out the solution which was by querying all source table.I wanted to delete it since since the tool gives an option to delete before any response is posted. Since i didnt find that optionni thought mods would come along and delete it. Anyway since its been answered, i will award the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.