how to attach usb scanner with Oracle forms [message #529581] |
Wed, 02 November 2011 01:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bc527a3a024fa498a3a8c878ec82e08d?s=64&d=mm&r=g) |
new_oracle2011
Messages: 174 Registered: March 2011 Location: Qatar
|
Senior Member |
|
|
Is there any way to connect any scanner to the Form 6i. Before someone made Fujitsu scanner Fi 5120C to work with Oracle form that if a button is pressed, the scanner will scan the document which is placed inside it and saved in DB in blob column. But now this scanner is obsolete and discontinue. I don't know how that programmer had done because I didn't find any huge coding behind that button except the HOST (default procedure) and an exe file.
PROCEDURE Do_Image (MailId IN arc_mails.mail_id%TYPE,
IMode IN VARCHAR2) IS
DepName VARCHAR2(100);
FNServer VARCHAR2(100);
FNUser VARCHAR2(30);
FNPasswd VARCHAR2(30);
OPasswd VARCHAR2(20);
CnStr VARCHAR2(20);
cmnd_text VARCHAR2(200);
strLang VARCHAR2(2);
BEGIN
SELECT office_docclass, office_fnserver
INTO DepName, FNServer
FROM arc_office;
OPasswd := GET_APPLICATION_PROPERTY(PASSWORD);
CnStr := GET_APPLICATION_PROPERTY(CONNECT_STRING);
IF CnStr IS NULL THEN
CnStr := CONST_PKG.CNString;
END IF;
FNUser := CONST_PKG.FNUser;
APP_USR.passwd('FNET',USER,FNUser,FNPasswd);
IF IMode = 'S' THEN
COMMIT_FORM;
END IF;
IF NAME_IN('GLOBAL.Language') = CONST_PKG.ArabicLang THEN
strLang := CONST_PKG.ArabicLang_c;
ELSE
strLang := CONST_PKG.LatinLang_c;
END IF;
cmnd_text := 'DiwanRetrival.exe '||USER||','||OPasswd||','||CnStr||','||FNUser||','||
FNPasswd||','||FNServer||','||MailId||','||DepName||','||strLang||','||IMode;
HOST(cmnd_text);
END;
Please have a look on the code
[Updated on: Wed, 02 November 2011 01:20] Report message to a moderator
|
|
|
Re: how to attach usb scanner with Oracle forms [message #529590 is a reply to message #529581] |
Wed, 02 November 2011 02:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
No idea, sorry. You might search the Forms forum for "serial scanner" - maybe you'll find something useful. I remember that people (now and then) tried to connect different devices to a serial port - even if you don't find the solution posted in a topic, you might still contact these people (via private messages or e-mails, if they allow it).
|
|
|