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