Home » SQL & PL/SQL » SQL & PL/SQL » How to ignore errors and finish the loop?
How to ignore errors and finish the loop? [message #36411] Mon, 26 November 2001 08:26 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: Disallowing INSERT using Trigger
Next Topic: How do I recall data from an index?
Goto Forum:
  


Current Time: Sun Mar 29 23:49:22 CDT 2020