• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

Scanning of pdf format documents in oracle

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
anumoses
Asked:
anumoses
  • 3
  • 3
2 Solutions
 
slightwv (䄆 Netminder) Commented:
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
 
anumosesAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
sdstuberCommented:
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
 
anumosesAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
anumosesAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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