nvarchar to varchar2 (Oracle)

daehob42316144

09-07-2018

Hi All.

I have one question about oracle datatype.

When I  try to insert data by FDA, 'ORA-12704' error has occured.

        Detail information,

     1) Adobe Campaign Database : Oracle, nvarchar data type

     2) ODS(External Database) : Oracle, varchar2 data type

1524491_pastedImage_0.png

Please let me know how can I solve this problem.

Thanks,

Best Regards

Daeho

View Entire Topic

shrawans3153003

Employee

09-07-2018

HI Daeho,

You can also check character set in both databases.

Database

As mentioned in the link shared by Ananya , this issue could be

  • The string operands (other than an NLSPARAMS argument) to an operator or built-in function do not have the same character set.
  • An NLSPARAMS operand is not in the database character set.
  • String data with character set other than the database character set is passed to a built-in function not expecting it.

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.