tOracleOutput ORA-00926: missing VALUES keyword

[Anonymous]

Hi,

I've got a simple job which inserts values into an Oracle table via tOracleOutput however i get the oracle error ORA-00926: missing VALUES keyword. This leads me to think that the insert statement is not being generated properly by Talend, however, i've added an on subjob error to retrieve ((String)globalMap.get("tOracleOutput_1_QUERY")) but it is null. The oracle user has grants to be able to insert.

Has anyone any ideas or is this error masking a different problem?

Thanks

[Anonymous]

does anyone know why this happens? I've just found a job with 12 tOracleOutputs, i don't want to have to delete these and reimport them all again.

[fdenis]

did you have red line into code tab?
can you show us your job?
did you try to stop restart and run?

[zjing]

I have met a same problem. Finally, I found a solution.

1. define a key in tOracleOutput

2. In tOracleOutput>Simple parameters> Table, there just use the table's name, not schema.tableName

note: action on le table: default

Schema, you should definie it in the connection component

good luck