Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

CLOB datatype usage

667844Sep 29 2009 — edited Oct 1 2009
Hi All,

I have a requirement where the value of a item can exceed 4000 characters and is using a "html editor standard" item type. So I used clob datatype to store the value of this item in the database. When the value is more than 32512 bytes, I get an error "Bad Request
Your browser sent a request that this server could not understand.

mod_plsql: /pls/apex/wwv_flow.accept HTTP-400 Value param too long. Length is 63658. Upper limit is 32512".

But when the value of the item is less than 32512 and more than 27000 characters or so, I get another error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error ERR-1023 Unable perform validations. "

When the item value is less than 25000 bytes or so, I do not get any error and functions properly.

Is there any way I could remove the second error.

Thanks,
Vignesh

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 27 2009
Added on Sep 29 2009
0 comments
546 views