oracle 10g table containing BLOBS

Guys, We upload to oracle multiple pdf documents and they are stored in the table as a BLOB this is fine. What I would like to know is it possible to know what the size of the record that has been inserted or how big the pdf file is.

The reason I am asking is I have reason to believe that the automated method that we use to upload to oracle had an off day and has been uploading empty 0kb file to oracle and I want to check if this is true.

It may have only been doing this for a short period of time.

Any ideas
DarrenJacksonAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
dbms_lob.getlength

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_lob.htm#ARPLS66709

select dbms_lob.getlength(your_blob_column) from your_table;
0
 
DarrenJacksonAuthor Commented:
This is perfect exactly what I am looking for

Thank you
0
 
DarrenJacksonAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.