How to ignore errors and finish the loop? [message #36411] |
Mon, 26 November 2001 08:26 |
Quincy
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
Hi. I recently started writing packages, procedures etc. What I am trying to do is loop a cursor to execute some commands. However, some of the variables in the cursor will result in an error (integrity constraint), which, if I'm correct, by default ends the loop and exits the procedure. Is there a way to have the cursor continue on, and more or less, just ignore any errors?
----------------------------------------------------------------------
|
|
|
Re: How to ignore errors and finish the loop? [message #36413 is a reply to message #36411] |
Mon, 26 November 2001 11:05 |
hello
Messages: 17 Registered: November 2001
|
Junior Member |
|
|
What u can do is
say
loop
begin
ur commands here
............
.............
exception
when others then
null;
end ;
end loop;
In this way any errors raised by ur execution commands will be grabed by the exception part and the loop continues with out exiting.
----------------------------------------------------------------------
|
|
|