Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Rookie question
Can anybody tell me why these statements are generating errors? Thanks.
SQL> create or replace procedure test
2 is
3 begin
4 select * from emp_hist ;
5 end test ;
6 /
Warning: Procedure created with compilation errors.
SQL> create or replace procedure test
2 (v_dummy out number)
3 is
4 begin
5 select * from emp_hist ;
6 end test ;
7 /
Warning: Procedure created with compilation errors. Received on Thu Oct 16 1997 - 00:00:00 CDT