Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure and trigger compile errors
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