How to query the dba_source for a procedure
428184Jan 26 2009 — edited Jan 26 2009I queried the dba_source table for known text and return the text and name:
Select name, text from dba_source where text like '%show_ild%';
It returned :
DPCS
procedure show_ild ....................................................
How do I use this and query all the text?
If I user DPCS. show_ild as name it returns "No Rows"
Thanks.
STan