Clever Geek Handbook

Continue error in loop

The below loop is an expression that does various "things"

If it should throw an exception, it will "raise" it as well. I want to catch it and ignore it, and allow the loop to continue processing the next value in the array.

thank

WHILE indx IS NOT NULL LOOP

    table_dump_csv(tableList(indx), tableList(indx) || '.csv');

    indx := tableList.NEXT(indx);
END LOOP;
+1


source to share


1 answer


One possible approach ...

   WHILE indx IS NOT NULL LOOP

      BEGIN
         table_dump_csv(tableList(indx), tableList(indx) || '.csv');
      EXCEPTION
         WHEN OTHERS THEN
            -- Handle/Ignore the exception as appropriate
      END;


      indx := tableList.NEXT(indx);

   END LOOP;


Alternatively, you can change the procedure to a function that returns a success / failure code.

+2


source






More articles:


All Articles