You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » tOracleOutput missing keyword "VALUES"
Post a reply
Topic review (newest first)
- Benjamin_
- 2012-06-18 10:35:34
Thank you, that helped. Stupid mistake.
Regards,
Benjamin
- pedro
- 2012-06-18 10:30:07
Hi
I notice that what you typed in "Table" text field is "I2B2IDRT.IDRTHelper".
Please change it into "IDRTHelper".
Regards,
Pedro
- Benjamin_
- 2012-06-18 10:26:44
Okay,
i send you the exported items.
Regards
- pedro
- 2012-06-18 10:19:36
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
- Benjamin_
- 2012-06-18 10:07:34
done,
thank you!
- pedro
- 2012-06-18 09:59:56
Hi
Could you send me an email and attach this job?
I will test it for you.
Regards,
Pedro
- Benjamin_
- 2012-06-18 09:56:50
No message is printed:
Starting job oracleTest at 09:55 18/06/2012.
[statistics] connecting to socket on port 3460
[statistics] connected
ORA-00926: missing values keyword
[statistics] disconnected
Job oracleTest ended at 09:55 18/06/2012. [exit code=0]
- pedro
- 2012-06-18 09:40:19
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
- Benjamin_
- 2012-06-18 09:33:13
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