Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

oracle 10g table containing BLOBS

Posted on 2016-07-19
3
Medium Priority
?
71 Views
Last Modified: 2016-07-19
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
Comment
Question by:DarrenJackson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 41719219
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
 

Author Comment

by:DarrenJackson
ID: 41719228
This is perfect exactly what I am looking for

Thank you
0
 

Author Closing Comment

by:DarrenJackson
ID: 41719229
Thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question