Database Error Messages

OCI-43912

invalid collation specified for a CLOB or NCLOB value

Cause

A character LOB column or expression was declared as having a collation other than USING_NLS_COMP or the determined collation for a collation-sensitive operator or function operating on character LOB values was not USING_NLS_COMP. Character LOB values support only the USING_NLS_COMP collation.


Action

Correct the collation declarations to make sure the USING_NLS_COMP collation is applied to the character LOB values.