Loading

Oracle database error 12704: ORA-12704: character set mismatch

Дата публикации: Apr 13, 2024
Описание

Oracle database error 12704: ORA-12704: character set mismatch. when using a calculated field.

Cause

Per this oracle dba article Strings declared with NCHAR or NCHAR VARYING do not interoperate with strings declared with CHAR or VARCHAR2.
Решение
Use TRANSLATE() function to explicitly convert one to the other.
Номер статьи базы знаний

001474211

 
Загрузка
Salesforce Help | Article