Re: Query for specific procedure's source code

From: Adam Cameron <adam_junk_at_hotmail.com>
Date: Sun, 1 Mar 2009 12:06:19 +0000
Message-ID: <5nb69vituryw.3ejmil55ppmw$.dlg_at_40tude.net>



> Afaik, there is no such method in Oracle.
> You can get the whole package source (either from *_source or with
> dbms_metadata ), but then you have to parse it to obtain a code for
> particular packaged procedure/function.
> I personally would avoid to write a plsql parser in plsql.
> Perl,python,java,whatever else are much better suitable for that (it is
> not as trivial as to search for "procedure foo", even not with
> "regexp_like(text,"procedure\s+foo") etc).

Cheers Maxim. Yeah, that's how it's beginning to seem to me too.

Thanks for the confirmation.

-- 
Adam
Received on Sun Mar 01 2009 - 06:06:19 CST

Original text of this message