The procedure must continues past any exceptions and completes as many actions as possible. What are my options in PL/SQL for doing this?
In Oracle Database 10g and higher, PL/SQL offers three options for “continuing past an exception”, which really means avoiding termination of the execution of the current block.