4 Replies Latest reply: Apr 13, 2010 5:04 AM by spilgrim RSS

    How to implement the spell check in oracle forms 10g or 6i...

    751122
      How to implement the spell check in oracle forms.
      Is there any different method is there.

      Please help me....


      Praveen.K
        • 1. Re: How to implement the spell check in oracle forms 10g or 6i...
          Andreas Weiden
          How to implement the spell check in oracle forms.
          Have a look at this Re: check spelling
          Is there any different method is there
          Different from what?
          • 2. Re: How to implement the spell check in oracle forms 10g or 6i...
            49905
            Here is one different from Jspell..
            In 6i client/server you can call MS Word spell checker using OLE. Below sample code for 6i.
            For 10g you will need webutil to use same code. install webutil and just replace "OLE2." with "CLIENT_OLE2."
            PROCEDURE spell_check (item_name IN VARCHAR2)
            IS
               my_application   ole2.obj_type;
               my_documents     ole2.obj_type;
               my_document      ole2.obj_type;
               my_selection     ole2.obj_type;
               get_spell        ole2.obj_type;
               my_spell         ole2.obj_type;
               args             ole2.list_type;
               spell_checked    VARCHAR2 (4000);
               orig_text        VARCHAR2 (4000);
            BEGIN
               orig_text := NAME_IN (item_name);
               my_application := ole2.create_obj ('WORD.APPLICATION');
               ole2.set_property (my_application, 'VISIBLE', FALSE);
               my_documents := ole2.get_obj_property (my_application, 'DOCUMENTS');
               my_document := ole2.invoke_obj (my_documents, 'ADD');
               my_selection := ole2.get_obj_property (my_application, 'SELECTION');
               ole2.set_property (my_selection, 'TEXT', orig_text);
               get_spell :=ole2.get_obj_property (my_application, 'ACTIVEDOCUMENT');
               ole2.invoke (get_spell, 'CHECKSPELLING');
               ole2.invoke (my_selection, 'WholeStory');
               ole2.invoke (my_selection, 'Copy');
               spell_checked := ole2.get_char_property (my_selection, 'TEXT');
               spell_checked :=SUBSTR (REPLACE (spell_checked, CHR (13), CHR (10)),1,LENGTH (spell_checked));
               COPY (spell_checked, item_name);
               args := ole2.create_arglist;
               ole2.add_arg (args, 0);
               ole2.invoke (my_document, 'CLOSE', args);
               ole2.destroy_arglist (args);
               ole2.RELEASE_OBJ (my_selection);
               ole2.RELEASE_OBJ (get_spell);
               ole2.RELEASE_OBJ (my_document);
               ole2.RELEASE_OBJ (my_documents);
               ole2.invoke (my_application, 'QUIT');
               ole2.RELEASE_OBJ (my_application);
            END;
            Call it like this: SPELL_CHECK ('BLOCK.MY_TEXT_ITEM' );
            • 3. Re: How to implement the spell check in oracle forms 10g or 6i...
              749590
              Have you got any documentation for installing Jspell SDK on 10G Oracle Application Sever

              Thanks
              Yaaminy
              • 4. Re: How to implement the spell check in oracle forms 10g or 6i...
                spilgrim
                Just type "jspell forms 10g" into Google and you'll get the Oracle Demos that should provide all you need to implement it.