ORA-3137 [12333] On MERGE Statement Using A Bind Variable Larger Than 1000 bytes

(Doc ID 2307683.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

If the merge statement have two long bind variables, then failing is the expected behavior. For details refer to Document : Merge is Failing with ORA-3137 [12333] (Doc ID 2039740.1)

But ORA-3137 [12333] error occurs although the merge statement have only a long bind variable.

There are two test cases for confirming this issue.

 

Cause

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