Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 2 similar statements, one works, one doesn't. Why?
Gentle readers, can someone tell me why one of these statements works
and the other
doesn't ? Thanks.
SQL> create or replace procedure test
2 is
3 begin
4 update emp_hist
5 set id = 13
6 where id = 9999 ;
7 end test ;
8 /
Procedure created.
SQL> create or replace procedure test
2 is
3 begin
4 select * from emp_hist ;
5 -- update emp_hist 6 -- set id = 13 7 -- where id = 9999 ;
Warning: Procedure created with compilation errors. Received on Thu Oct 16 1997 - 00:00:00 CDT
![]() |
![]() |