Receiver jdbc adapter failure - Error: ORA-00917: missing comma

[Former Member]

The Issue is related to a PI interface where we are trying to pick the data from .CSV file and inserting the data in Oracle DB. We are facing the problem at receiver end which is a JDBC adapter. Message is going in to error status with the following error.

Error Message: Unable to execute statement for table or stored procedure. 'CREDIT_CST_SL_MAP' (Structure 'StatementName') due to java.sql.SQLSyntaxErrorException: ORA-00917: missing comma

[Former Member]

Hi Apu,

Please see the scrren shots below

[apu_das2]

Hi,

Please paste your receiver data type and receiver CC configuration. Looks like it's simple data/configuration issue.

Thanks,

Apu

[Former Member]

sorry my bad

Kindly guide me how to put semi colon at the end of each SQL statement.

[Former Member]

Thank you for the Reply.

The query which you are seeing in the scrren shot is generated by PI only, Sales rep status is of type number, that is the reason I did not put that in inverted commas.

Kindly guide me how to put inverted commas at the end of each sql statement. 🙂

[Former Member]

We don't use native sql JDBC channels but rather XML SQL - but could you please try putting a semi colon at the end of your statement. If that doesn't work, could you also try putting the 1 (sales rep status) inside inverted comma's.