I have one question about oracle datatype.
When I try to insert data by FDA, 'ORA-12704' error has occured.
1) Adobe Campaign Database : Oracle, nvarchar data type
2) ODS(External Database) : Oracle, varchar2 data type
Please let me know how can I solve this problem.
You can also check character set in both databases.
As mentioned in the link shared by Ananya , this issue could be
Also you can enable to sql log and see what actual query is being generated when you perform update and how it is different from the query which is there in Java script.