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!

Checking the size of Form items defined as Browse File

LauryNov 28 2017 — edited Dec 3 2017

Hi,

I am working with APEX 5.1.

I have a form fild, P25_CUSTOMER_IMAGE, that has been created with these properties:

- Display As: File Browse...

- Storage Type: BLOB column specified in Item Source attribute

I wish to have a validation that checks if that BLOB if "filled", if not filed, and error shoud be returned.

I use a procedure that takes as parameter a BLOB, and checks its size using: nvl((sum(dbms_lob.getlength("BLOB variable"))),0).

But when I assign: nvl((sum(dbms_lob.getlength(:P25_CUSTOMER_IMAGE))),0), it returns me an inconsistent data type.

How can I achieve this check?

Thanks by advance for any tip.

Kind Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2017

Added on Nov 28 2017

#apex-discussions

7 comments

383 views