PL/SQL Block Fails to Update all Records when Subpartitions are being Truncated
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 10.1.0.5 to 184.108.40.206 - Release: 10.1 to 11.1
Information in this document applies to any platform.
This problem is triggered when the session performing the bulk DML gets an internal ORA-14403 error during processing of the array batch. This internal ORA-14403 is normal but in the problem case it is not handled correctly.
Setting an ERRORSTACK on 14403 will help show if that error is occurring and dump errorstack information for every 14403 error.
SQL> ALTER SYSTEM SET EVENTS '14403 trace name errorstack level 3';
To switch off the event run:
SQL> ALTER SYSTEM SET EVENTS '14403 trace name context off';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms