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

Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure and trigger compile errors

Re: Procedure and trigger compile errors

From: Mary <mdellamalva_at_cetec.com>
Date: 2000/07/21
Message-ID: <8laor6$32t@journal.concentric.net>#1/1

Hi,

Try:

SQL> SHOW ERRORS PROCEDURE PROC1 SQL*Plus User's Guide has more information on the SHOW ERROR command.

Hope it helps

Mary
Cetec Automation
mdellamalva_at_cetec.com

Aaron <asentell_at_my-deja.com> wrote in message news:8lam0k$65g$1_at_nnrp1.deja.com...
> I've looked and looked, but I haven't been able to find the answer to
> this question: When creating a stored procedure and/or trigger in
> Oracle and it has errors but is still created, where do I find what
> exactly is causing the compilation error? Isn't there a table
> somewhere that details this?
>
> Thanks,
> Aaron
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 21 2000 - 00:00:00 CDT

Original text of this message

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