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
