Re: show errors shows nothing

Hi Ron,

try one of the following:

        show errors trigger your_trigger_name
or

        select * from user_errors;

provided you're connected to the database user in which the trigger was created, you know.

Yours
Stefan.

Ron McCamish wrote:
>
> i just created a trigger with compilation errors:
>
> Warning: Trigger created with compilation errors.
>
> so, like always, i did a 'show errors' to see what I
> screwed up. but, 'show errors' yields 'No errors'!!
>
> is there another way that i can look at the errors
> and/or fix this?
>
> I'm using Oracle 7.3.3.0.0, SQL*Plus 3.3.3.0.0,
> PL/SQL 2.3.3.0.0.
>
> thanks,
>
> ron....
>
> --
> Ron McCamish
> rmccamish_at_cas.org
Received on Tue Oct 28 1997 - 00:00:00 CST