I have a test Oracle system running on a NT. The following procedure eats
up 100% cpu power of NT. I could only get out of the SQL envirement by
killing the session. Could somebody please enlighten me how to prevent
such kind of problem to do harm to the oracle system? Thanks.
create or replace procedure testo is
cursor geto is select * from test;
rr test%rowtype;
begin
open geto;
loop
fetch geto into rr;
--exit when geto%notfound; -- without this line it executes forever
end loop;
end;
/
Received on Tue Mar 14 2000 - 00:00:00 CST
