From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

tOracleOutput missing keyword "VALUES"

Highlighted
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
Highlighted
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
Highlighted
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.
Highlighted
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
Highlighted
One Star

Re: tOracleOutput missing keyword "VALUES"

done,
thank you!
Highlighted
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
Highlighted
One Star

Re: tOracleOutput missing keyword "VALUES"

Okay,
i send you the exported items.
Regards
Highlighted
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
Highlighted
One Star

Re: tOracleOutput missing keyword "VALUES"

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

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog