Re: Scanning the source code ?

Richard Elliott wrote:
>
> I need to scan all the objects for the occurance of several "key"
> words. If possible I would like to extract all the source for the
> objects and put it in a single table with the object name, object type
> and line of source as a row.
>
> Is there an easy way to do this, or can I scan the data dictionary
> directly. I don't need to update any data, just run some like()
> clauses against the source.
>
> I am looking for "Hardcoded" items such as Company Name etc..in the
> procedures, packages, functions etc..
>
> Thanks in advance for any/all help.

dba_source contains the source code for pl/sql

triggers are little more of a pain because the source is stored in a long in dba_triggers

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"