I am having something weird occur ; Any ideas? Thank you
<messages>
<input><UpdateApprovalStatus_InputVariable><part name="ref_DB_UpdateApprovalStatusInput_msg"><ref_DB_UpdateApprovalStatusInput><workflowID>3079</workflowID><approval>APPROVED</approval>
<eamStatus>PENDING</eamStatus>
<actsStatus>APPROVAL</actsStatus>
<lastUpdateDate>2017-09-19</lastUpdateDate>
<recId>25</recId>
<recSeq>2</recSeq>
</ref_DB_UpdateApprovalStatusInput>
</part>
</UpdateApprovalStatus_InputVariable>
</input>
<fault>
<bpelFault><faultType>0</faultType><bindingFault>
<part name="summary"><summary>Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'ref_DB_UpdateApprovalStatus' failed due to: Pure SQL Exception. Pure SQL Execute of update BOLINF.NBL_USO_ENGINE_INTERFACE set ACTS_WORKFLOW_ID = ? , ACTS_APPROVAL = ?,EAM_INTER_STATUS = ? , ACTS_INTER_STATUS = ? , LAST_UPDATED_BY = 'SOA', LAST_UPDATE_DATE = ? where REC_ID = ? and REC_SEQ = ? failed. Caused by java.sql.SQLSyntaxErrorException: ORA-01722: invalid number . The Pure SQL option is for border use cases only and provides simple yet minimal functionality. Possibly try the "Perform an operation on a table" option instead. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-1722" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. </summary> </part>
<part name="detail">
<detail>ORA-01722: invalid number </detail> </part>
<part name="code">
</bindingFault>
</bpelFault>
</fault>
<faultType>
</messages>
the .jca is as follows
<?xml version = '1.0' encoding = 'UTF-8'?>
<xs:schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/db/ref_DB_UpdateApprovalStatus" xmlns="http://xmlns.oracle.com/pcbpel/adapter/db/ref_DB_UpdateApprovalStatus" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="ref_DB_UpdateApprovalStatusInput" type="ref_DB_UpdateApprovalStatusInput"/>
<xs:complexType name="ref_DB_UpdateApprovalStatusInput">
<xs:sequence>
<xs:element name="workflowID" type="xs:decimal" nillable="true"/>
<xs:element name="approval" type="xs:string" nillable="true"/>
<xs:element name="eamStatus" type="xs:string" nillable="true"/>
<xs:element name="actsStatus" type="xs:string" nillable="true"/>
<xs:element name="lastUpdateDate" type="xs:dateTime" nillable="true"/>
<xs:element name="recId" type="xs:decimal" nillable="true"/>
<xs:element name="recSeq" type="xs:decimal" nillable="true"/>
</xs:sequence>
</xs:complexType>
</xs:schema>
and the SQL is as follows
update BOLINF.NBL_USO_ENGINE_INTERFACE set ACTS_WORKFLOW_ID = #workflowID , ACTS_APPROVAL = #approval,EAM_INTER_STATUS = #eamStatus , ACTS_INTER_STATUS = #actsStatus , LAST_UPDATED_BY = 'SOA', LAST_UPDATE_DATE = #lastUpdateDate where REC_ID = #recId and REC_SEQ = #recSeq