on 08-13-2013 8:00 AM
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.