<div>
This is perfect exactly what I am looking for<br />
<br />
Thank you
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
It may have only been doing this for a short period of time.<br />
<br />
Any ideas
</div>
</div>


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

oracle 10g table containing BLOBS

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.