This content has been marked as final. Show 2 replies
ORA-06512: at "VRESS.NESTED_PROC", line 18
One or more rows of your FORALL failed and you didn't trap the exception so your code blew up.
When bulk processing with FORALL you need to trap the bulk exception if you want processing to continue if an error is encountered with one of the records.
You are trapping AN exception
but that is not the bulk exception that you need to trap. You need to trap ORA-24381.
Example 12-9 shows how you can perform a number of DML operations, without stopping if some operations encounter errors. In the example, EXCEPTION_INIT is used to associate the DML_ERRORS exception with the predefined error ORA-24381. ORA-24381 is raised if any exceptions are caught and saved after a bulk operation.
See Handling FORALL Exceptions in the PL/SQL Language Reference