Re: 2 similar statements, one works, one doesn't. Why?

Have you tried to see what errors the 2nd statement gave you ?

Try "show errors" immediately after the statement execution gives you better error where did it failed.

Andy
andychan_at_usa.net

rsenn wrote:
>
> 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 ;
> 8 end test ;
> 9 /
>
> Warning: Procedure created with compilation errors.
  Received on Sun Oct 19 1997 - 00:00:00 CDT