Exceptions within a loop

[Eels]

Basically I am going through each row in a table like this:
CREATE OR REPLACE PROCEDURE
testProc
IS


CURSOR hd_cur IS
SELECT *
FROM table;

BEGIN
FOR hd_rec IN hd_cur
LOOP

IF something
THEN
RAISE exception



EXCEPTIONS


END LOOP;


END;

Within the loop there will be some if statements and i want to raise an exception in some cases. But I need to pass all the values in the row to exceptions so i can insert them into another table. Is it possible to do something like above?

Also I want to loop to continue to the next row after as well. Any ideas?


Any help appreciated!

[DaPi]

I don't see the point of raising an exception that you will trap in the same block. Why not just put your "exception" processing in the if?

[pando]

begin
   for i in (select blah blah)
   loop
      begin
         if ... then
            blah blah
         end if;
      exception
         when .... then
            blah blah
      end;
   end loop;
end;
/