One Star

Usage of "additional columns" in tOracleOutput?

Hello!
I'm new to Talend Open studio and I wonder how to use the "Additional columns" feature within the "Advanced settings" of the tOracleOutput- component.
I only found some small mysql example in the web which doesn't help much.
What "name" is meant in the list? What does it exactly do?
I have a database table with "id" as the key column and tried the following in my tOracleOutput:
Name: "id"
SQL expression: "select LW_LEIST_SEQ.NEXTVAL from dual" (the sequence exists)
position: "after"
reference column: "id"
but when i try to execute the job i get "ORA-00936: missing expression"
Can anybody help me?
Thank you!
Stefan
3 REPLIES
One Star

Re: Usage of "additional columns" in tOracleOutput?

Hi,

Normaly the name "ID" is reserved in Oracle DB.

Jeremie
One Star

Re: Usage of "additional columns" in tOracleOutput?

Hello!
Well we DO HAVE a key column named "id" in our table and it works.
Stefan
One Star

Re: Usage of "additional columns" in tOracleOutput?

I just found out the problem:
SQL should be "LW_LEIST_SEQ.NEXTVAL" instead of "select LW_LEIST_SEQ.NEXTVAL from dual".
Thanks!