cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Exception

Former Member
0 Kudos

Hi,

I am extracting several rows data from SAP using a standard BAPI and uploading it to a Oracle table. I am receiving the following error -

[WARN ]: com.sap.xmii.Illuminator.logging.LHException: com.sap.xmii.Illuminator.logging.LHException: java.sql.SQLException: ORA-00907: missing right parenthesis

[ERROR]: ACTION FAILED: End Action SQL_Query_0 : (SQL Query)

[WARN ]: com.sap.xmii.Illuminator.logging.LHException: com.sap.xmii.Illuminator.logging.LHException: java.sql.SQLException: ORA-00907: missing right parenthesis

I am getting this error only when I choose a particular field from SAP. For any other field, I choose I do not receive this error. Can somebody help? Thanks.

Regards,

V M.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Its a special character in the data that SQL has an exception with. Resolved successfully.

0 Kudos

Venki,

Perhaps some specific query details would make it more understandable. Missing right parentheses sometimes comes up when there is an unexpected number or object where Oracle expects a parentheses. Can you show your expression editor contents?

Regards,

Mike