I have a quastion can i generate the next value of an oracle sequence , to insert into a primary key of a table ,with talend in the composant troaclerow , or what should i do
You have changed your component configuration to be wrong. You are attempt to write the value from the sequence in a column called seq_value ? I have no idea why do you did that. Please take a look to the picture in your post#16 here is everything OK! The reference column does not matter, please ignore it.
I change the name of the column name becaue the primary key of my table has the name : ID_HTTP_TRACE so i put in the additional column the name of the column that should be the primary key and in the refrenced column the same what's wrong with my configuration please
Obviously I am unable to explain it to you.
I assume: You have a table with the primary key column ID_HTTP_TRACE which you want to fill with the value of a sequence - that it what you explained so far. Now you tell me you want to use a new column for the primary key called seq_values ok but the primary key column will not filled this way -> you get the error.
OK: If you want to fill the column
ID_HTTP_TRACE with the value from the sequence - hell - than do it by adding exactly this column as additional column in the component. You have to use it as additional column because only this way you can bring the sequence into the game for this column.
Go to the advanced setting of tOracleOutput and set as name "ID_HTTP_TRACE" and keep the SQL expression and ignore what ever you can read as reference Column and damned this will work.
Mr jlolling
in the script table the primary key is id_http_trace , forget the seq_value is just i try to understant the componenet,
so if i put in the additional column
the name of the column the same the refrenced column , i have this error :
ORA-00957: duplicate column name
and if i put what ever in the refrenced column i have the error that it can't be null
how can do it , or how can i do it with the toracleRow
Thanks
