3 Replies Latest reply: Mar 19, 2011 8:44 AM by 36417 RSS

    broken links - webutil - aiming this primarily at a forum moderator

    333287
      The following links are broken:

      www.oracle.com/technology/products/forms/htdocs/webutil/howto_ole.html
      and
      www.oracle.com/technology/products/forms/htdocs/webutil/webutil.htm
      point to
      http://www.oracle.com/technetwork/developer-tools/forms/overview/index.html

      www.oracle.com/technology/documentation/9i_forms.htm
      points to
      http://www.oracle.com/technetwork/indexes/documentation/index.html

      www.oracle.com/technology/software/products/forms/files/webutil/webutil_106.zip
      points to
      http://www.oracle.com/technetwork/indexes/downloads/index.html

      I'm trying to find out how to use webutil to open/edit/close Word or Notepad in Forms 10g, storing as a BLOB and am sure the above links would be helpful.]
      Are the links likely to be fixed soon or should I look for other sources of information?

      Thanks,

      Simon
        • 1. Re: broken links - webutil - aiming this primarily at a forum moderator
          Cjmurray-Oracle
          I'm not a moderator, but have passed along the information to someone on the OTN team. As for how soon the links might be fixed, or whether you should seek the information from other sources, I don't know.
          • 2. Re: broken links - webutil - aiming this primarily at a forum moderator
            389703
            simonjamison, the OTN Website moved to a new CMS some time ago; you are referring to legacy URLs.

            All the links you are looking for are found on http://www.oracle.com/technetwork/developer-tools/forms/overview/index.html, in one place or another. Specifically, if you are looking for WebUtil info:

            http://www.oracle.com/technetwork/developer-tools/forms/webutil-090641.html

            The How-To you reference is no longer available on OTN, but I have pasted the text below for your reference:
            HOW TO - Performing OLE on the client using WebUtil
            Introduction

            Many Forms applications utilize OLE to perform tight integration with the Windows desktop. However, when moving your Forms application to the Web,
            the calls to OLE are now running on the application server and not the client machine.

            Typically you need OLE to access the machine at which the user is sitting and integrate with the OLE services on the client.
            For example, loading data into an Excel worksheet and display for the user.

            WebUtil provides you the functionality to perform client side OLE integration from within the Forms Java applet.

            Set up

            For the steps to set up WebUtil, please refer to the WebUtil Familiarization Manual available as part of the software download.

            Changing code

            Consider the following code:

            DECLARE
            app OLE2.OBJ_TYPE;
            docs OLE2.OBJ_TYPE;
            doc OLE2.OBJ_TYPE;
            selection OLE2.OBJ_TYPE;
            args OLE2.LIST_TYPE;
            BEGIN
            -- create a new document
            app := OLE2.CREATE_OBJ('Word.Application');
            OLE2.SET_PROPERTY(app,'Visible',1);

            docs := OLE2.GET_OBJ_PROPERTY(app, 'Documents');
            doc := OLE2.INVOKE_OBJ(docs, 'add');

            selection := OLE2.GET_OBJ_PROPERTY(app, 'Selection');

            -- insert data into new document from long item
            OLE2.SET_PROPERTY(selection, 'Text', :long_item);

            -- save document as example.doc
            args := OLE2.CREATE_ARGLIST;
            OLE2.ADD_ARG(args, 'c:\temp\example.doc');
            OLE2.INVOKE(doc, 'SaveAs', args);
            OLE2.DESTROY_ARGLIST(args);

            -- close example.doc
            args := OLE2.CREATE_ARGLIST;
            OLE2.ADD_ARG(args, 0);
            OLE2.INVOKE(doc, 'Close', args);
            OLE2.DESTROY_ARGLIST(args);

            OLE2.RELEASE_OBJ(selection);
            OLE2.RELEASE_OBJ(doc);
            OLE2.RELEASE_OBJ(docs);

            -- exit MSWord
            OLE2.INVOKE(app,'Quit');
            END;

            This code opens a Word document to the user and inserts data from a Forms text field into that Word document before saving and closing the file. To perform
            the same functionality, but on the client side when deployed on the Web, attach the WebUtil object library and PL/SQL library,
            and replace any instance of OLE2 with CLIENT_OLE2.

            The resulting code will now work, as before, but write the file to the client machine.

            DECLARE
            app CLIENT_OLE2.OBJ_TYPE;
            docs CLIENT_OLE2.OBJ_TYPE;
            doc CLIENT_OLE2.OBJ_TYPE;
            selection CLIENT_OLE2.OBJ_TYPE;
            args CLIENT_OLE2.LIST_TYPE;
            BEGIN
            -- create a new document
            app := CLIENT_OLE2.CREATE_OBJ('Word.Application');
            CLIENT_OLE2.SET_PROPERTY(app,'Visible',1);

            docs := CLIENT_OLE2.GET_OBJ_PROPERTY(app, 'Documents');
            doc := CLIENT_OLE2.INVOKE_OBJ(docs, 'add');

            selection := CLIENT_OLE2.GET_OBJ_PROPERTY(app, 'Selection');

            -- insert data into new document from long item
            CLIENT_OLE2.SET_PROPERTY(selection, 'Text', :long_item);

            -- save document as example.doc
            args := CLIENT_OLE2.CREATE_ARGLIST;
            CLIENT_OLE2.ADD_ARG(args, 'c:\temp\example.doc');
            CLIENT_OLE2.INVOKE(doc, 'SaveAs', args);
            CLIENT_OLE2.DESTROY_ARGLIST(args);

            -- close example.doc
            args := CLIENT_OLE2.CREATE_ARGLIST;
            CLIENT_OLE2.ADD_ARG(args, 0);
            CLIENT_OLE2.INVOKE(doc, 'Close', args);
            CLIENT_OLE2.DESTROY_ARGLIST(args);

            CLIENT_OLE2.RELEASE_OBJ(selection);
            CLIENT_OLE2.RELEASE_OBJ(doc);
            CLIENT_OLE2.RELEASE_OBJ(docs);

            -- exit MSWord
            CLIENT_OLE2.INVOKE(app,'Quit');
            END;
            • 3. Re: broken links - webutil - aiming this primarily at a forum moderator
              36417
              A copy of
              Oracle® Forms Developer WebUtil User’s Guide Release 1.0.6 August 2005
              is available at:
              http://www.villanova.edu/unit/assets/documents/admin/web_util.pdf