How to receive more detailed error information?

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 Received on Fri Sep 14 2001 - 05:57:51 CDT