asked on

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?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anumoses

ASKER

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?

slightwv (䄆 Netminder)

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.

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anumoses

ASKER

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

slightwv (䄆 Netminder)

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?

anumoses

ASKER

thanks