How to receive more detailed error information? Part 2

From: Chris Smith <joker_5166_at_yahoo.com>
Date: 14 Sep 2001 07:32:20 -0700
Message-ID: <132368bb.0109140632.9871777@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 - 09:32:20 CDT