Re: debug compiled packages

From: John Russell <netnews4_at_johnrussell.mailshell.com>
Date: Sat, 31 Aug 2002 05:10:22 GMT
Message-ID: <kkj0nu4h8kpcssjhj9j5e9jtqhjnohb33q@4ax.com>

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_flags&book=&preference=&expand_all=1

John Received on Sat Aug 31 2002 - 00:10:22 CDT