Scanning of pdf format documents in oracle

Posted on 2013-01-23
Last Modified: 2013-01-29
I have a new project that I am working on hospitals. There is a contract table and the user wants to scan pdf documents and store in the database. Is is possible to save on windows and then insert that into oracle tables or better to use external directories? Also I was looking at few examples online.

Can someone suggest me the best way to do this? Any examples other than the online one?
Question by:anumoses
  • 3
  • 3
LVL 76

Accepted Solution

slightwv (䄆 Netminder) earned 250 total points
ID: 38810010
This will likely become a large debate here.

There are two schools on this:  Store documents on the file system and use a BFILE or store them in the database as a BLOB.

The reality is both have their pros and cons.

I prefer storing them in the database.  It makes backup and recovery much easier.  It also simplifies data integrity.

Someone could delete a file from the file system.  Then you no longer have integrity between what is in the database and what is on the file system.

Another deciding factor is how the PDFs will be used in the applications.  If they are commonly accessed and used, then databaes storage might make more sense.

Author Comment

ID: 38810039
There are two schools on this:  Store documents on the file system and use a BFILE or store them in the database as a BLOB.

Any examples that you suggest?
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38810047
None that I can suggest off the top of my head.

There are likely many examples and papers out there if you Google around.  The docs have the specifics on BFILEs and BLOBs.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 73

Assisted Solution

sdstuber earned 250 total points
ID: 38810127
If you have APEX 4.2 installed, it comes with a sample file upload/download application that will allow you to load a pdf (or any other file) from your pc to a BLOB within the database.

Author Comment

ID: 38820389
This is the form I am working. In the contract section I will provide an icon and on the trigger event I want to populate the pdf of the contract.
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38820616
Is there sensitive information in that image you uploaded?  If so, you might want to delete it.

>>I want to populate the pdf of the contract

OK, what does this new information have to do with the question of where to store the PDF?

Author Closing Comment

ID: 38830749

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle regular expression 6 45
Insert and update a row at the same time 4 49
Converting a row into a column 2 43
Get the parent node - XMLTYPE 9 56
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

911 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now