Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jan 08, 2017 at 10:59 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 05:51 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 08:03 AM

    sorry my bad

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 08:14 AM

    Hi,

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

    Thanks,

    Apu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2017 at 10:35 AM

    Hi Apu,

    Please see the scrren shots below

    Add comment
    10|10000 characters needed characters exceeded