Skip to Main Content
Forums

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!

Howto check size of BLOB image before upload?

788134Aug 5 2010 — edited Apr 15 2011
I have a table which stores images as BLOB. I want those images to be 1Mb large, or less. How do I check the size of a BLOB, before insert?

I've tried to check this in a before insert trigger on the table with a check on dbms_lob.getlength(IMAGE_FIELD) but the size seems to be 0 at that point.

I want the size to be checked before upload / insert. Is it possible to check this on upload in APEX?

I'm now using APEX 4.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2011
Added on Aug 5 2010
#apex, #apex-discussions, #file, #validation
10 comments
4,806 views