Home » RDBMS Server » Server Administration » Re: Extremely Urgent
Re: Extremely Urgent [message #373466] Wed, 18 April 2001 11:27
Neal Hawman
Messages: 14
Registered: April 2001
Junior Member
I'm not sure if you mean an ordinary "for" loop or a cursor for loop. Assuming the former, you could put the "for" loop inside another loop:

loop_failed = true;
while loop_failed = true loop
loop_failed := false;
for i in 1..end_point loop
if (failure_condition)
loop_failed := true;
exit;
end if;
end loop;
end loop;

or, if you wanted to start from where you finished last time:

start_point := 1;
loop_failed = true;
while loop_failed = true loop
loop_failed := false;
for i in start_point..end_point loop
if (failure_condition)
loop_failed := true;
exit;
start_point := i;
end if;
end loop;
end loop;
Previous Topic: ref cursor
Next Topic: Re: how to delet a view from database
Goto Forum:
  


Current Time: Mon Dec 23 10:19:25 CST 2024