Re: debug compiled packages

Pete Finnigan 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
> --
> 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"

I would guess it would be resident in the compiled code - so the IDL_... tables may be the only source (ugh!)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

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