Error Inserting Record Into CLOB Datatype Of Size More Then 32766 Characters (Doc ID 400239.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version 10.1.2.0.2 to 10.1.3.1 [Release AS10gR2 to AS10gR3]
Information in this document applies to any platform.
***Checked for relevance on 03-Feb-2010***
***Checked for relevance on 04-Aug-2011***
***Checked for relevance on 15-July-2013***

Symptoms

When trying to insert a record into a CLOB with a size greater than 32KB using the database adapter you receive the following error in the log files:

java.sql.SQLException: setString can only
process strings of less than 32766 chararacters Internal Exception:
java.sql.SQLException: setString can only process strings of less than 32766
chararacters Error Code: 17157 when trying to insert record in clob type of
size more then 32766 characters

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