Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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 ---------------------------------------------------------------Received on Tue Jul 11 2000 - 00:00:00 CDT
![]() |
![]() |