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

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.9 [23016] and later
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

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