2 Replies Latest reply: Feb 1, 2013 4:40 AM by HamidHelal RSS

    Quit Excel from Oracle Forms

    kaminanikamini
      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.
        • 1. Re: Quit Excel from Oracle Forms
          kaminanikamini
          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;
          • 2. Re: Quit Excel from Oracle Forms
            HamidHelal
            kaminanikamini wrote:
            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.
            Hi kaminanikamini

            Please follow the link.
            1. http://www.orafaq.com/forum/t/88643/2/
            1. Closeing Excel with OLE2

            Hope this works for you..


            Hamid