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!

ORA-22835; Error- ORA-22835: Buffer too small for BLOB to CHAR; APEX 19

marussigJun 26 2019 — edited Jun 28 2019

I have a problem with displaying the image saved in BLOB column. Is there some solution what to do with the buffer or something?

This is a syntax:

SELECT ...

, '<img src="'||apex_util.prepare_url('f?p='||:APP_ID||':0:'||:APP_SESSION||':APPLICATION_PROCESS=GETIMAGE:::FILE_ID:'||my_id_col||':'||:DEBUG)||'" />' img

FROM my_table

thanks

pastedImage_7.png

Comments
Post Details
Added on Jun 26 2019
5 comments
442 views