OraFAQ Forum: Forms » Quit Excel from oracle forms

Home » Developer & Programmer » Forms » Quit Excel from oracle forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Quit Excel from oracle forms [message #575320]

Tue, 22 January 2013 04:04

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.

Report message to a moderator

Re: Quit Excel from oracle forms [message #576056 is a reply to message #575320]

Thu, 31 January 2013 03:56

Akarsh
Messages: 16
Registered: November 2012
Location: India

Junior Member

any one please help me?

Report message to a moderator

Re: Quit Excel from oracle forms [message #576134 is a reply to message #576056]

Thu, 31 January 2013 23:00

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;

Report message to a moderator

Re: Quit Excel from oracle forms [message #576145 is a reply to message #576134]

Fri, 01 February 2013 00:12

Littlefoot
Messages: 21808
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?

Report message to a moderator

Re: Quit Excel from oracle forms [message #576147 is a reply to message #576145]

Fri, 01 February 2013 00:24

Akarsh
Messages: 16
Registered: November 2012
Location: India

Junior Member

Yes Sir,
I tried on OTN Forum also.
But no reply from that..

Report message to a moderator

Re: Quit Excel from oracle forms [message #576153 is a reply to message #576147]

Fri, 01 February 2013 00:56

Littlefoot
Messages: 21808
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.

Report message to a moderator

Previous Topic:	Updating record must be an exception to the query.
Next Topic:	Unable to make the form fields available to edit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:37:42 CDT 2024