My Oracle Support Banner

CLOB field can only save 32KB data (Doc ID 1601626.1)

Last updated on JUNE 12, 2024

Applies to:

Siebel CRM - Version 8.1.1.9 [23016] to 16.14 [IP2016] [Release V8 to V16]
Information in this document applies to any platform.

Symptoms

Usually CLOB field can handle 128KB as documented in Bookshelf 'Configuring Siebel Business Applications' at [A Reference Materials for Configuring Siebel Business Application]->[Properties of Object Types]->[Properties of a Table Column]->[Physical Type Property of a Table Column]->[Character Large Object (CLOB) Physical Type]. But with the following 2 cases, CLOB field can save only 32KB or you will see ORA-01460 error.

(1) When you create a new record and try to save the record.

(2) When you update a record with other fields which involves other table(s).

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.