How to search a table in a store proc and open the store proc
How to search a table in a store proc and open the store proc
1. select * from dba_dependencies where referenced_name='CNTL_ISSUE' and TYPE='PROCEDURE' 2. select text from all_source where name = 'SP_ARA_TEMPALTE_UPLOAD' and type = 'PROCEDURE' order by line