Re: show errors shows nothing

From: Frédéric Trébuchet <frederic.trebuchet_at_aigf.sncf.fr>
Date: 1997/10/29
Message-ID: <636v56$fe6@rennes.sncf.fr>#1/1

The SQL*Plus command SHOW ERROR only apply to the last component you compile. If you want to retrieve error(s) for a particular trigger/package/procedure/... specify the type and the name of the object. For example, "show error trigger trig_name".

Ron McCamish <rmccamish_at_cas.org> 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 Wed Oct 29 1997 - 00:00:00 CST