Skip to Content
0

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

Jan 06, 2017 at 01:57 PM

86

avatar image

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

capture1.jpg (62.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Dan Kennedy Jan 08, 2017 at 10:59 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
venkatrami reddy donakanti Jan 09, 2017 at 05:51 AM
0

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. :)

Share
10 |10000 characters needed characters left characters exceeded
venkatrami reddy donakanti Jan 09, 2017 at 08:03 AM
0

sorry my bad

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

Share
10 |10000 characters needed characters left characters exceeded
Apu Das Jan 09, 2017 at 08:14 AM
0

Hi,

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

Thanks,

Apu

Share
10 |10000 characters needed characters left characters exceeded
venkatrami reddy donakanti Jan 09, 2017 at 10:35 AM
0

Hi Apu,

Please see the scrren shots below


dt-capture.png (22.5 kB)
cc1-capture.png (13.3 kB)
cc2-capture.png (14.6 kB)
Share
10 |10000 characters needed characters left characters exceeded