Re: Viewing package compilation errors

Matthieu DEGLIN wrote:
>
> Hello,
>
> When executing @cre_my_package in a sqlplus session I encounter:
>
> Warning, package created with compilation errors.
>
> How can I see those errors using only sql commands (I mean without using
> tools such as Toad).
>
> Thanks for help.
>
> Matt.

show errors package body BLAH

which is actually just a query to the USER_ERRORS view

hth
connor

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

http://www.oracledba.co.uk

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