Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ooops shouldn't have been using the tXMLMap, swapped it for tMap.
In the end it was fixed by deleting the tOracleOutput component and reimporting it from the repository. I can only assume there was a value mapped incorrectly somewhere or the table definition had changed since it was last imported.
Thanks for you help everyone.
Hi fdenis, there is no sql insert query option in the tOracleOutput component. i am mapping values striaght into tOracleOutput via a tMap.
Hi,
We have not seen your schema. But I believe you are missing some schema elements and that is the reason for your issue. Could you please print the output and see the details using a tLogrow? Also please verify the output schema is in sync with input schema from previous component. This also create the likelihood for the above error.
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Hi,
It looks decent. Since you are using a tXMLMap, could you please print the output of it to a tLogrow instead of tOracleOutput and see the output?
Warm Regards,
Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Ooops shouldn't have been using the tXMLMap, swapped it for tMap.
In the end it was fixed by deleting the tOracleOutput component and reimporting it from the repository. I can only assume there was a value mapped incorrectly somewhere or the table definition had changed since it was last imported.
Thanks for you help everyone.