Re: How to receive more detailed error information?

joker_5166_at_yahoo.com (Chris Smith) wrote in message news:<132368bb.0109140257.30169845_at_posting.google.com>...
> Using Oracle 8.0.5 and sqlplus, I try the following:
>
> SQL> create procedure p1
> 2 as begin
> 3 select * from emp;
> 4 end;
> 5 /
>
> Warning: Procedure created with compilation errors.
>
> 1. How can I receive more detailed error information?
> 2. Was the procedure really created? I can't execute it...
> 3. How can I get an overview about existing procedures?
>
> TIA, Chris

You must select into something: select x into var from ...

From sqlplus you can normally execute the command 'show errors' immediately after attempting to create a procedure and see the errors.  If this does not work query user_errors or dba_errors. The contents of user_errors exists only for the life of the session so you cannot exit and edit and then reconnect and query for more error messages without re-executing the code.

• Mark D Powell --