How to Scan and Save Images into Oracle Database?
August 3rd, 2008 By sunita
I have a requirement to scan and save a photograph through a program without user interaction in Oracle 10g. How can I do this job?
I m using TWAIN program but it throws a window error, and I am not able to save it in specific directory.
Plz reply.
Thanks & Regards
Sunita
August 4th, 2008 at 3:55 pm
Firstly, do you mean Oracle Database 10g, or is this a Forms environment ?
Secondly, what do you mean “without user interaction”. Since you say ’scan’, I assume this photograph is a physical object (not a digital photograph). As such, at some point a user will need to do something with it (ie put it in/on the scanner and press some button somewhere that will, in some way, tell the scanner that there is something to scan).
So the first step is, how do I physically operate that scanner to get a file containing a digital record of that image.
The second step is, how/where can I put that file such that it can be accessed by the database (which depends on the network connectivity of the scanner and/or computer it is connected to).
You could consider an XDB repository set up as a WebDav folder accessible to that machine. Then simply saving or moving that file to that directory will save it in the database.
Otherwise you’ll need some form of folder accessible to the database (directly or through a protocol such as FTP) where it can read the directory and read the files contained in it.