Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Client_ole2 EXCEL.EXE process not killed

414966Mar 25 2004 — edited Nov 30 2007
Hi,

In a webForm I open an Excel file with Client_ole2.

When I close Excel the underlying process is not killed; I can still see an EXCEL.EXE process in my task manager.

The consequence is that I can’t open an Excel file (by double-clicking one) while the above mentioned process is still running.
The EXCEL.EXE process keep on running until the local JVM shuts down.

Can anyone give some advise what to do?
Is this perhaps a known bug in webutil?

Code.
I use the following code (Extract):
………
elsif upper(substr(l_locatie_client,-4,4)) in ('.XLS','.CSV') then

-- open Excel
application := CLIENT_OLE2.CREATE_OBJ ('Excel.Application');
-- maak visible
CLIENT_OLE2.SET_PROPERTY(application,'Visible',1);

-- open document
workbooks := CLIENT_OLE2.get_obj_property(application, 'workbooks');
ArgList := CLIENT_OLE2.create_arglist;
--
CLIENT_OLE2.Add_Arg(ArgList, l_locatie_client);
workbook := CLIENT_OLE2.Invoke_obj(workbooks,'Open', Arglist);
CLIENT_OLE2.Destroy_Arglist(Arglist);

-- release objects
CLIENT_OLE2.Release_Obj(workbook);
CLIENT_OLE2.Release_Obj(workbooks);
CLIENT_OLE2.Release_Obj(Application);

CLIENT_OLE2.invoke(Application,'Quit');

else
qms$show_message('Can’t open this type of file.', 'I', FALSE);
end if;

specifications.

server:
Microsoft Windows 2000
Service Pack 3
Oracle 9iAS 9.0.2.3.0
Webutil 1.0.2

Client:
Microsoft Windows XP
Professionel version 2002
JInitiator version 1.3.1.13
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2007
Added on Mar 25 2004
7 comments
1,513 views