Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: pl/sql oracle 7.3.4

Re: pl/sql oracle 7.3.4

From: Stephan Born <sborn_at_beusen.de>
Date: 2000/07/11
Message-ID: <396B00B8.5D5DB93E@beusen.de>#1/1

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US