JDBC XML SQL error
Hi experts,
Please, can anyone help me with an issue regarding JDBC XML SQL?
I'm trying to insert data into Oracle database using JDBC Adapter.
The payload is:
<?xml version="1.0" encoding="UTF-8" ?> - <ns1:MT_MyMessageType xmlns:ns1="urn:company-com:xpt:comp"> - <Statement> - <TB_MYORACLETABLE action="INSERT"> - <access> <FIELDNAME1>SA</FIELDNAME1> <FIELDNAME2>SAP7</FIELDNAME2> </access> </TB_MYORACLETABLE> </Statement> </ns1:MT_MyMessageType>
And I'm geting this error:
Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TB_MYORACLETABLE' (structure 'Statement'): java.sql.SQLException: ORA-01861: literal does not match format string
