Continue on error in loop

Question

The loop below is callign a proc that does various 'things'

If it should throw an exception it also 'raises' it. I want to catch it and ignore it and allow the loop to continue processing the next value in the array.

Thanks

WHILE indx IS NOT NULL LOOP

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

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

Answer 1

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 could change the procedure into a function which returns a success/failure code.