Home » Developer & Programmer » Forms » Quit Excel from oracle forms
Quit Excel from oracle forms [message #575320] Tue, 22 January 2013 04:04 Go to next message
Akarsh
Messages: 16
Registered: November 2012
Location: India
Junior Member
I am using Oracle forms 10.1.20.2 and Excel 2007.

I have written the following code to Quit Excel But This removes Excel from the desktop but the application still runs. If you view the task mamager you see all the excel application there taking up all the recourse.

ole2.release_obj(worksheet1);
ole2.invoke (workbooks1, 'Close');

OLE2.release_obj(Workbook1 );
OLE2.release_obj(Workbooks1 );
ole2.invoke (application, 'Quit');
OLE2.release_obj(application );

SYS.DBMS_SESSION.free_unused_user_memory;


Thanks.
Re: Quit Excel from oracle forms [message #576056 is a reply to message #575320] Thu, 31 January 2013 03:56 Go to previous messageGo to next message
Akarsh
Messages: 16
Registered: November 2012
Location: India
Junior Member
any one please help me?
Re: Quit Excel from oracle forms [message #576134 is a reply to message #576056] Thu, 31 January 2013 23:00 Go to previous messageGo to next message
Akarsh
Messages: 16
Registered: November 2012
Location: India
Junior Member
Hello Every one,
As Excel instance is not released i found so many excel Application resources taking place in Task manager.This wont accepted..
And we r fetching Data from Excel files frequently.
Please Please help me to solve this.

I tried this code, but no luck

ole2.invoke (workbooks1, 'Close');
ole2.release_obj(worksheet1);
OLE2.release_obj(Workbook1 );
OLE2.release_obj(Workbooks1 );
ole2.invoke (application, 'Quit');
OLE2.release_obj(application );

SYS.DBMS_SESSION.free_unused_user_memory;


Re: Quit Excel from oracle forms [message #576145 is a reply to message #576134] Fri, 01 February 2013 00:12 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It's been a week since you asked the question, but it appears that noone of the regulars here knows the answer. You might wait - someone might assist - but, perhaps you'd rather ask for help elsewhere. Did you try OTN Forums?
Re: Quit Excel from oracle forms [message #576147 is a reply to message #576145] Fri, 01 February 2013 00:24 Go to previous messageGo to next message
Akarsh
Messages: 16
Registered: November 2012
Location: India
Junior Member
Yes Sir,
I tried on OTN Forum also.
But no reply from that..
Re: Quit Excel from oracle forms [message #576153 is a reply to message #576147] Fri, 01 February 2013 00:56 Go to previous message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From my point of view: you are using a wrong tool. Oracle = RDBMS, keyword is a database. What you are trying to do is an operating system issue. The fact that you can do that using Oracle (probably; I can't tell) doesn't mean that you should use Oracle.
Previous Topic: Updating record must be an exception to the query.
Next Topic: Unable to make the form fields available to edit
Goto Forum:
  


Current Time: Thu Aug 21 11:08:39 CDT 2014

Total time taken to generate the page: 0.09274 seconds