Error Inserting More Than 4000 Characters Into CLOB Column (Doc ID 2172550.1)

Last updated on AUGUST 31, 2016

Applies to:

Siebel Financial Services CRM - Version 8.1.1.14 [IP2014] and later
Information in this document applies to any platform.

Goal

On : 8.1.1.14 [IP2014] version, Configuration - General

Error inserting more than 4000 characters into CLOB column


Customer has custom table with a CLOB column defined of length 1,376,256 bytes, but when users insert a value that exceeds 4000 characters users get the following error:
"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