Query to Compile_dependent_objects in Oracle

 

query to Compile_dependent_objects

       

select owner, name, type, referenced_owner, referenced_name, referenced_type ,
owner sdev_link_owner, name sdev_link_name, type sdev_link_type
,'ALTER '|| case when TYPE='PACKAGE BODY' then 'PACKAGE' else type end ||' '|| owner ||'.' || name ||' compile ;' query
from Dba_DEPENDENCIES
where referenced_owner = 'referenced_owner' and referenced_name = 'referenced_name';