Re: How to receive more detailed error information? Part 2

From: larry.j <ljohnson_at_lodinet.com>
Date: Fri, 14 Sep 2001 08:50:31 -0700
Message-ID: <tq49k0c7jk0547@corp.supernews.com>

Try: show error procedure p1

vice show errors

Larry Johnson

KeepItSimpleEngineering,Inc.

"Chris Smith" <joker_5166_at_yahoo.com> wrote in message news:132368bb.0109140632.9871777_at_posting.google.com...
> I posted on this before. Thank you for your comments.
> (You are right, I am new to Oracle.)
>
> I have a problem creating procedures and I don't know why.
> It could be a problem of missing rights, but this is speculative.
> What I am looking for is a means to gather more information about the
> reason why *all* my CREATE PROCEDURE calls fail.
>
> Here my sqlplus session:
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> SQL> create procedure p1
> 2 as begin
> 3 delete * from emp;
> 4 end;
> 5 /
>
> Warning: Procedure created with compilation errors.
>
> SQL> show errors
> No errors.
> SQL> select * from user_errors;
>
> no rows selected
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
>
> Is it possible to receive more information about the compilation
> errors?
>
> TIA, Chris.
Received on Fri Sep 14 2001 - 10:50:31 CDT