Re: debug compiled packages

Hi John

Thanks very much for the reply, the flag that you refer to is used for native compilation in 9i and specifies a set of comma separated compiler flags to the PL/SQL compiler. I am looking to identify if a specific piece of PL/SQL has been compiled with debug. This flag is global not per piece of PL/SQL.

Thanks for the reply and info though

kind regards

Pete

In article <kkj0nu4h8kpcssjhj9j5e9jtqhjnohb33q_at_4ax.com>, John Russell <netnews4_at_johnrussell.mailshell.com> writes
>On Fri, 30 Aug 2002 19:27:56 +0100, Pete Finnigan
><pete_at_peterfinnigan.demon.co.uk> wrote:
>
>>Hi All
>>
>>does anyone know how you can tell if a piece of PL/SQL (trigger,
>>procedure, function, package etc) has been compiled with debug, is it
>>possible to tell. I have searched the documentation and google and could
>>not find anything and had a good look around the data dictionary but
>>couldn't find anything obvious there either.
>>
>>version is anything from 7.3.4 to 9i, if there is a difference.
>>
>>thanks
>>
>>kind regards
>>
>>Pete
>
>PLSQL_COMPILER_FLAGS parameter in 9i:
>
>http://tahiti.oracle.com/pls/db92/db92.drilldown?remark=&word=plsql_compiler_fl
>a
>gs&book=&preference=&expand_all=1
>
>John

-- 
Pete Finnigan

pete_at_peterfinnigan.demon.co.uk
pete_at_petefinnigan.com

http://www.petefinnigan.com

http://online.securityfocus.com/infocus/1522 - "A simple Oracle Security
Scanner"

http://downloads.securityfocus.com/library/oracle-security.pdf - "Exploiting and 
protecting Oracle"