on 01-09-2009 3:29 AM
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.
Its a special character in the data that SQL has an exception with. Resolved successfully.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.