tOracleOutput missing keyword "VALUES"

One Star

tOracleOutput missing keyword "VALUES"

Hi all,
I'm using TOS 5.0.1.r74687-64bit on windows 7 64bit.
I'm trying to upload data into my Oracle DB using tOracleOutput. I get the Oracle error:
ORA-00926: missing VALUES keyword
Although the java source code contains the keyword, I still get the error. Does anyone know a solution to this?
String insert_tOracleOutput_2 = "INSERT INTO " + tableName_tOracleOutput_2 + " (column1, column2) VALUES (?,?)";

Regards,
Benjamin
One Star

Re: tOracleOutput missing keyword "VALUES"

Hi Benjamin
Please use tJava to print ((String)globalMap.get("tOracleOutput_1_QUERY")) by using "OnsubjobError" on tOracleOutput. The query may be not correct.
Do not select "Die on error" option on tOracleOutput.
Regards,
Pedro
One Star

Re: tOracleOutput missing keyword "VALUES"

No message is printed:
Starting job oracleTest at 09:55 18/06/2012.
connecting to socket on port 3460
connected
ORA-00926: missing values keyword
disconnected
Job oracleTest ended at 09:55 18/06/2012.
One Star

Re: tOracleOutput missing keyword "VALUES"

Hi
Could you send me an email and attach this job?
I will test it for you.
Regards,
Pedro
One Star

Re: tOracleOutput missing keyword "VALUES"

done,
thank you!
One Star

Re: tOracleOutput missing keyword "VALUES"

Hi Benjamin
It seems you didn't export this job correctly. I get an invalid zip file.
Step1: Right click on this job.
Step2: Select "Export Items".
Step3: Browser the name of this zip file and click on "Finish".
Regards,
Pedro
One Star

Re: tOracleOutput missing keyword "VALUES"

Okay,
i send you the exported items.
Regards
One Star

Re: tOracleOutput missing keyword "VALUES"

Hi
I notice that what you typed in "Table" text field is "I2B2IDRT.IDRTHelper".
Please change it into "IDRTHelper".
Regards,
Pedro
One Star

Re: tOracleOutput missing keyword "VALUES"

Thank you, that helped. Stupid mistake.
Regards,
Benjamin

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now