Error in Receiver JDBC communication channel

[santhosh_sontha2]

Hi friends,

I am getting an error in communication channel while inserting xml data into ORACLE database. Error is like

"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. 'SUB_ORDER_HEADER' (structure 'STATEMENT_SUB_ORDER_HEADER'): java.sql.SQLException: ORA-00936: missing expression ".

In the above error 'SUB_ORDER_HEADER' is table and 'STATEMENT_SUB_ORDER_HEADER' is a statement tag of XML SQL.

Please help me to solve the issue.

Regards,

Santhosh

[Former Member]

Hi,

Since oracle database has all fields in Caps, and also it is case sensitive. So check whether you have the database table name and the field name specified in the datatype are concurrent with the fields and the table name in oracle table.

Regards,

Nithiyanandam

[Former Member]

Please check your XML-SQL structure, it sounds that the translated SQL statment is not valid. You could also turn on the JDBC Adapter Additional Parameter to log the SQL statement.

regards,

Hai

[former_member267355]

Hi,

Check whether you have mapped correctly statement and table field.

Refer this blog,

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards,

Sakthi