ORABPEL-11802 Error Occurs When Inserting Data Into CLOB Field In DB Via DB Adapter (Doc ID 563982.1)

Last updated on JUNE 18, 2018

Applies to:

Symptoms

The following error occurs when inserting CLOB in a table column on database:

com.oracle.bpel.client.BPELFault: faultName:
{{http://schemas.oracle.com/bpel/extension}bindingFault} messageType:
{{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{code=null
,summary=file:/apps/oasstg/product/AS10gR3/bpel/domains/coe_domain/tmp/.bpel_LogErrorsAsync_1.0_88f1
d16e00b24578979b3aaf3825d4bd.tmp/CallBPELLogErrorProc.wsdl [
CallBPELLogErrorProc_ptt::CallBPELLogErrorProc(InputParameters,OutputParameters) ] - WSIF JCA
Execute of operation 'CallBPELLogErrorProc' failed due to: Error while converting to a Java
struct object. Unable to convert the XSD element IN_TBL_ERROR_MESSAGES_ITEM whose user defined
type is APPS.XXCCP_BPEL_ERROR_PKGIN_OBJ_T. Cause: java.lang.ClassCastException: oracle.sql.CLOB ;
nested exception is: ORABPEL-11802 Error while converting to a Java struct object. Unable to
convert the XSD element IN_TBL_ERROR_MESSAGES_ITEM whose user defined type is
APPS.XXCCP_BPEL_ERROR_PKGIN_OBJ_T. Cause: java.lang.ClassCastException: oracle.sql.CLOB Check to
ensure that the XML data describing the user defined type matches the definition of the struct in
the XSD. Contact oracle support if error is not fixable. ,detail=null }}

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.