tOracleOutput multi column primary key

[Anonymous]

Hello, i have one problem. I use in my project tOracleOutput. In my table I dont have primary key. But i want use in talend job multi column primary key. When i check (in tOracleOutput-Advanced settings-Use field options) checkbox only in one row (update) that is work fine, but when i check more rows, that ignore them and insert new rows.....can u help me with this ???
I use talend openstudio 6.2.1 and in tOracleOutput-Action on data i try both - "Insert or update" and "Update or insert"

[Anonymous]

Updatable was checked as default, I dont change it, but can I try i

[Anonymous · Accepted solution]

I found what was wrong, its my fault. In my schemas I have START_DATETIME and END_DATETIME as Date but in DB it is VARCHAR2...
After change, its working and dont insert duplicated values
Thanks you boys