Scanning Documents

Actually , implementing Java code that scans document will take time and much efforts. However i find out a workaround solution that enables you to scan document from oracle forms. The solution is in JAVA SCRIPT.

So, we created a Simple HTML file with simple java script that call Twain.Twain is an exe file that scans documents whatever the scanner type is. So you can use it with any type of scanner and Digital Cameras.

The scenario goes like this:

1- create a table that contains two columns :program blob ,program_path varchar2.

2- upload the file TwainGui.exe to the table in "program " column. "program_path" column represents the path that the user should download the file to it.

3-create an icon or button like "download" in your main form to enable end user to download "TwainGui.exe" from your database.

4- copy the html "scan.html" to htdocs in your application server

5- invoke the html using Web.Show_Document from your application form.

open the scan.html file with notepad and search for "shell.run("

take care of the path in "shell.run(" it must be the same path in "program_path" column

download the file

http://www.4shared.com/file/0UvEKaPd/scan.html

and copy the content into D:\ drive and double click on scan.html

How to create Your PJC from scratch

firstly I would like to thank my brother and my best friend Haythem for his valuable participation in this blog.

Many forms developers are interested in PJC(pluggable Java component) . But most o the problem is how to implement a new Java bean. In this demonstration , I shall discuss in Arabic language a very simple implementation for Java bean in forms world. I hope you enjoy it.

http://www.screentoaster.com/watch/stWUpWSk1IR19eRVteXltcVl5T/demo_to_drw_line_on_forms

this idea can be improved to be a drawing program that used for furniture manufacturer to read the dimension of the pieces from the database and output the result in graphic shapes.