Error Inserting More Than 4000 Characters Into CLOB Column

(Doc ID 2172550.1)

Last updated on MARCH 05, 2018

Applies to:

Siebel Financial Services CRM - Version 8.1.1.14 [IP2014] and later
Information in this document applies to any platform.
Relevance checked on 05 march 2018.

Goal

CONTEXT: custom table with a CLOB column defined of length 1,376,256 bytes.

Why do users encounter below error while inserting more than 4000 characters into CLOB column?
"SBL-DAT-00520: Your entry for field 'Note' is too long to fit in a UTF-8 encoded enterprise database. Please try again with a shorter entry."


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms