PL/SQL Block Fails to Update all Records when Subpartitions are being Truncated
(Doc ID 548943.1)
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 10.1.0.5 to 126.96.36.199 - 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';
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!