Re: pl/sql oracle 7.3.4

> I'm trying to compile a pl/sql trigger. I run a little script in sql,
> and get a message saying that the procedure compiled with compilation
> errors.
>
> But, when I type "Show errors", I get a message saying there are no
> errors!
>

The complete syntax for SHOW ERRORS is explained here:

SHOW ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY|TRIGGER|VIEW} [ schema.] name]

If you type only SHOW ERRORS you get the errors for the most recently compiled/altered/created STORED PROCEDURE!!! You have to specify that you want to see errors for TRIGGERS!

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------