Why Would the Fluid Approval Page throw SQL error "ORA-22835: Buffer Too Small For CLOB To CHAR Or BLOB To RAW Conversion (actual: 4058, Maximum: 4000)"? (Doc ID 2356347.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Goal

 The Fluid Approvals page is throwing the following error while loading if the comments for the transaction exceed 4000 characters in length"

"File: E:pt85513b-retailpeopletoolssrcpspcmpcmosql.cppSQL error. Stmt #: 760 Error Position: 243 Return: 22835 - ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4058, maximum: 4000)"

Is there a way to avoid this error while still entering large amounts of text in the comments field?

Solution

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