Solved

Scanning of pdf format documents in oracle

Posted on 2013-01-23
7
562 Views
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.
http://www.dba-oracle.com/t_table_blob_lob_storage.htm

https://forums.oracle.com/forums/thread.jspa?threadID=706609

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

Accepted Solution

by:
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.
0
 
LVL 6

Author Comment

by:anumoses
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?
0
 
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.
0
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

by:sdstuber
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.
0
 
LVL 6

Author Comment

by:anumoses
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.
scan-pdf.JPG
0
 
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?
0
 
LVL 6

Author Closing Comment

by:anumoses
ID: 38830749
thanks
0

Featured Post

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.

Question has a verified solution.

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

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
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 connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

825 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