topic Re: tOracleOutput ORA-00926: missing VALUES keyword in Talend Studio

tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Wed, 12 Jun 2019 12:32:14 GMT

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

Re: tOracleOutput ORA-00926: missing VALUES keyword

fdenis — Wed, 12 Jun 2019 13:05:01 GMT

what is your sql insert query?
normally this error come when you inert values without "values" word in your query string.
(it also may due to parentheses).

Re: tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Wed, 12 Jun 2019 13:58:37 GMT

Hi fdenis, there is no sql insert query option in the tOracleOutput component. i am mapping values striaght into tOracleOutput via a tMap.

Re: tOracleOutput ORA-00926: missing VALUES keyword

fdenis — Wed, 12 Jun 2019 14:08:22 GMT

ok sorry did you have data on your flow?
you can add tlog on orange link to see them.

Re: tOracleOutput ORA-00926: missing VALUES keyword

fdenis — Wed, 12 Jun 2019 14:09:50 GMT

did you have schema on your input link?

Re: tOracleOutput ORA-00926: missing VALUES keyword

fdenis — Wed, 12 Jun 2019 14:11:02 GMT

if you are java friendly, you can go to code tab looking for red lines.

Re: tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Wed, 12 Jun 2019 14:43:50 GMT

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 🙂

Re: tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Wed, 12 Jun 2019 14:56:27 GMT

What I’ve done to troubleshoot the issue is just create a simple job where I have hard coded some values in the tMap just so I can isolate the problem to the tOracleOutput component. See the attached screenshot, there is data flowing from tMap to tOracleOutput. The job compiles fine, there are no errors or warnings showing in the java tab. Screenshot of the schemas attached from both Talend and oracle.
Untitled.png
Schema.JPG

Re: tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Wed, 12 Jun 2019 15:36:19 GMT

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 🙂

Re: tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Wed, 12 Jun 2019 16:40:24 GMT

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.

Re: tOracleOutput ORA-00926: missing VALUES keyword

Anonymous — Thu, 13 Jun 2019 11:52:34 GMT

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.

Re: tOracleOutput ORA-00926: missing VALUES keyword

fdenis — Thu, 13 Jun 2019 12:51:41 GMT

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

Re: tOracleOutput ORA-00926: missing VALUES keyword

zjing — Tue, 18 Feb 2020 08:42:57 GMT

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