Skip to Content

Error when executing statement for table/stored proc. 'V_XX_XX_XX' (structure 'Statement'): java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification

Hi Experts,

My scenario is IDOC to JDBC, i have created structure as per the table record field names only.

But i am getting the below error

Error when executing statement for table/stored proc. 'V_XX_XX_XX' (structure 'Statement'): java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification

According to my log at receiver side,:

INSERT INTO V_XX_XX_XX(PLAN_NO, LOADING_POINT, LOADING_DATE, RECIPIENT, DELIVERY_DATE, CARRIER, USER, REMARK, PRODUCT, WEIGHT, WAGON_AMOUNT, STATUS, STATUS_DATE, RECORD_SENDER) VALUES (2099, XX, 2013-08-12 12:50:31, XX, 2013-08-12 12:50:31, SDF, XX, GHDK, SOK, 1400, 23, N, 2013-08-12 12:50:31, IRAIL)

According to the database guy, the above data worked with few changes

INSERT INTO V_XX_XX_XX(PLAN_NO, LOADING_POINT, LOADING_DATE, RECIPIENT, DELIVERY_DATE, CARRIER, "USER", REMARK, PRODUCT, WEIGHT, WAGON_AMOUNT, STATUS, STATUS_DATE, RECORD_SENDER)
VALUES (3040, 'XX', to_date('2013-08-12 08:41:29', 'yyyy-mm-dd hh24:mi:ss'), 'XX', to_date('2013-08-12 08:41:29', 'yyyy-mm-dd hh24:mi:ss'), 'SDF', 'XX', 'GHDK', 'SOK', 1400, 23, 'N', to_date('2013-08-12 08:41:29', 'yyyy-mm-dd hh24:mi:ss'), 'IRAIL');

The above works according to above query.

can anybody please let me know what are the changes that i need to do to get data inserted with out this error.

Regards,

Rohini

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 13, 2013 at 10:42 AM

    Hi Rohini,

    Your DB table has a column that is a reserved word in SQL, "USER", this is the problem orign. The normal issue would be to have a table with a column name that won't be a reserver word. You could try with the SQL_DML XML format for the JDBC receiver.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded