Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 76
  • Last Modified:

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
0
DarrenJackson
Asked:
DarrenJackson
  • 2
1 Solution
 
slightwv (䄆 Netminder) 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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now