search

foex-open-source / fos-ckeditor4

A Rich Text Editor for Oracle APEX based on CKEditor4.
MIT License
9 stars 5 forks source link

FOS - CKEditor4 buffer size problem #4

Open uvarol opened 1 year ago

uvarol commented 1 year ago

First of all, thank you for providing such an item. I have two questions. First, I used FOS - CKEditor4 as a clob field. It does not take more than 32k in the create process. The second one gives a 4k buffer error in the update process. I think it's getting stuck at the apex service limit. How can I solve these?

stefandobre commented 1 year ago

Which APEX version? And do you mean "CLOB field" as in Session State CLOB? (APEX 22.2+) If so, have you seen this? https://github.com/foex-open-source/fos-ckeditor4/issues/3

As to this:

The second one gives a 4k buffer error in the update process. I think it's getting stuck at the apex service limit.

I'm not sure what that means.

uvarol commented 1 year ago

Hi, version 22.1

Here is the error I get when updating a record with 10k image in it: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 32767, maximum: 4000)

stefandobre commented 1 year ago

What is a 10k image? Are you inlining images as base64? The 4000 limit might come from your DB's MAX_STRING_SIZE setting, which could be bumped up to 32k.

uvarol commented 1 year ago

yes the image is inline, I guess it converts to base64.

Also, when making the first recording, if there is an image larger than 32k, it does not record it either.