NCHAR issue with oracle database using JDBC adapter

[Former Member]

Hi,

We have a requirement to develop an XI interface from FTP server(File adapter) to oracle database using JDBC adapter. In the oracle database table few fields are of type NCHAR/NVARCHAR. when we try to insert the character(A,B,c..) values into oracle table fields of type NCHAR/NVARCHAR, we are getting the following error message in the JDBC adapter audit log. IF we pass the numeric value to the same field, then we are able to insert the records successfully.

Unable to execute statement for table or stored procedure. 'IPCSDD_DOWNLOAD_PROCESS' (Structure 'StatementName1') due to java.sql.SQLException: ORA-00904: "P": invalid identifier

2010-10-19 22:29:59 Error JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'IPCSDD_DOWNLOAD_PROCESS' (structure 'StatementName1'): java.sql.SQLException: ORA-00904: "P": invalid identifier

2010-10-19 22:29:59 Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'IPCSDD_DOWNLOAD_PROCESS' (structure 'StatementName1'): java.sql.SQLException: ORA-00904: "P": invalid identifier

Please find the system information below.

Oracle version- 10.2.4

XI version - 3.0/ service pack 19

JDBC driver- oracle.jdbc.driver.OracleDriver

Please suggest.

Thanks,

Venkata

Edited by: Venkata Narayana Eepuri on Oct 21, 2010 12:10 AM

[Former Member · Accepted solution]

NCHAR and NVARCHAR data types are both Unicode character data types.

We have to set N infront of the string to pass it as NCHAR/NVARCHAR

Refer que# 27 in note 831162 for clarification.

[Former Member]

Dear Venkata Narayana,

Concerning the error, kindly go through the following note :

731 - Collective note: ORA-00904

follow the recommendations mentioned in that and please check if that helps.

Best Regards

Nishwanth