problem running jacob.dll on 64 bit client computer
SiatGesiDec 10 2012 — edited Dec 20 2012hi,
I am using CLIENT_OLE2 package to create a Word file into the client's computer. For example, this code snippet downloads a text from a DB table, write it into a Word document, and save it into the user's computer
DECLARE
V_APP BOOLEAN;
BEGIN
V_APP :=WEBUTIL_FILE_TRANSFER.DB_To_Client
('C:\'||FILE_NAME||'.DOCX',
'DB_TABLE,
'DB_COLUMN,
'WHERE CLAUSE);
IF V_APP THEN
hApplication:=CLIENT_OLE2.CREATE_OBJ('Word.Application');
CLIENT_OLE2.SET_PROPERTY(hApplication, 'Visible',1);
--write into Word document
CLIENT_OLE2.RELEASE_OBJ(hApplication);
END IF;
END;
when I test the application on my computer (O.S. Windows 7 SP1, 64bit), the app remains blocked, and the java console displays this message
C:\Program Files\Java\jre6\bin\jacob.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform
my computer has O.S. Windows 7 64bit SP1, and Microsoft Office Professional Plus 2010, version 14.0.6123.5001 (32 bit); while the AS runs on a Windows 2003 Server and Oracle Database 10g Enterprise Edition Release 10.2.0.1.0.
How can I fix this bug? thanks for help