Re: debug compiled packages

Thanks Lloyd,

I found the view created in $ORACLE_HOME/rdbms/admin/prvtpb.plb, Connor was right its in the idl_char$ table.

thanks again

kind regards

Pete

In article <Ez3c9.45529$6m61.5264_at_news04.bloor.is.net.cable.rogers.com>, Lloyd Sheen <sqlguy_at_hotmail.com> writes
>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"