Re: debug compiled packages

There is the user_probe_objects and all_probe_objects views.

The field debuginfo will be either 'T' or 'F'. 'T' for PL/SQL which has been compiled for debug.

Lloyd Sheen

"Pete Finnigan" <pete_at_peterfinnigan.demon.co.uk> wrote in message news:gJ3QhKBsk7b9Ewhy_at_peterfinnigan.demon.co.uk...
> 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"
>
Received on Sat Aug 31 2002 - 08:32:20 CDT