SQL & PL/SQL

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!

Oracle Lite 10.3.0: how to find out the consumed size of a BLOB column

460493Jan 15 2011 — edited Jan 16 2011

Hi,

we are developing an app that utilizes an Oracle Lite database and so far I have just been unable to find a reasonable way to determine the size of stored binary data.

All the "usual" ways we aware of from "main" Oracle just don't seem to work with OLIte (ie SELECT dbms_lob.getlength(file_data) from APPS.CSL_LOBS) so how does one find out the size of blob objects?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2011

Added on Jan 15 2011

#blob

12 comments

675 views