CLOB field can only save 32KB data
Last updated on MAY 17, 2018
Applies to:Siebel CRM - Version 126.96.36.199  and later
Information in this document applies to any platform.
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms