Exception handling continue loop with out break

scharan07 · #1 (**permalink**) 08-26-10, 04:23

Hi,

I have written a procedure, in which i have cursor, looping through the cursor,
i want to handle exception in this loop such way that it should continue with the next iteration not to break out the loop.

magicwand · #2 (**permalink**) 08-26-10, 06:53

That's how to do it (in this example, a divide by zero - exception is caught):

Code:

begin
  for i in 1..10 loop
    begin
       dbms_output.put_line('i | i / (i - 5):' || i || '|' || i / (i - 5));
    exception
       when ZERO_DIVIDE then dbms_output.put_line ('This Line from exception handler') ;continue;
       when others      then dbms_output.put_line('Error: ' || SQLCODE || ' ' || SQLERRM); exit;
    end;
  end loop;
end;
/

Output:

Code:

i | i / (i - 5):1|-,25
i | i / (i - 5):2|-,6666666666666666666666666666666666666667
i | i / (i - 5):3|-1,5
i | i / (i - 5):4|-4
This Line from exception handler
i | i / (i - 5):6|6
i | i / (i - 5):7|3,5
i | i / (i - 5):8|2,66666666666666666666666666666666666667
i | i / (i - 5):9|2,25
i | i / (i - 5):10|2

scharan07 · #3 (**permalink**) 08-27-10, 02:46

i am using 10g continue statement is giving error.

Quote:

"PLS-00201: identifier 'CONTINUE' must be declared"

My code goes like this

Code:

begin
<expressions>
exception
when others  then 
dbms_output.put_line('Error: ' || SQLCODE); 
continue;
END;

anacedent · #4 (**permalink**) 08-27-10, 10:08

>i am using 10g continue statement is giving error.

Please post URL to documentation for said "CONTINUE" statement.

magicwand · #5 (**permalink**) 08-27-10, 18:27

scharan07,

you can simply omit the CONTINUE in 10g (in 11g CONTINUE just starts the next loop of the iteration).

The important thing is, to handle the exception in a block within the loop.

anacedent,

CONTINUE Statement

scharan07 · #6 (**permalink**) 08-30-10, 04:30

So it is newly introduced in 11g.
In 10g it auto do's with out continue statement.

Thanks for you replies magicwand

Internet Services

Web Development

Digital Marketing

Consumer Tech