10 Replies Latest reply: Feb 19, 2013 3:50 AM by user2626293 RSS

    Error in Forms

    user2626293
      Dear All,

      Database version: 11g
      Forms Version: 10.1.2.0.2

      I have built a simple form based on the employee table and i have included a download button. Form compiles fine, but when i run the form i get the below error.

      FRM-40039: Cannot attach library webutil while opening form EMP_DWNLD

      As this is forms 10.1.2.0.2 there was no need to configure WEBUTIL. I have attached this library to my Form, and the PATH is set in the registry and my default.env file as well.

      I cant understand why this doesn't work. Please advice.

      Thanks and Regards
      Srinivas
        • 1. Re: Error in Forms
          HamidHelal
          user2626293 wrote:
          Dear All,

          Database version: 11g
          Forms Version: 10.1.2.0.2

          I have built a simple form based on the employee table and i have included a download button. Form compiles fine, but when i run the form i get the below error.

          FRM-40039: Cannot attach library webutil while opening form EMP_DWNLD

          As this is forms 10.1.2.0.2 there was no need to configure WEBUTIL. I have attached this library to my Form, and the PATH is set in the registry and my default.env file as well.

          I cant understand why this doesn't work. Please advice.
          Hello Srinivas,
          when attaching library in forms Click YES when asking for remove path.
          And paste all your library .pll and .plx at
          <forums_home>\forms
          Hope this works..

          Hamid
          • 2. Re: Error in Forms
            user2626293
            Hi Hamid,

            Thanks for your response. I have done that when i was adding the library, but still the same issue persists.

            Thanks and Regards
            Srinivas
            • 3. Re: Error in Forms
              HamidHelal
              user2626293 wrote:
              Hi Hamid,

              Thanks for your response. I have done that when i was adding the library, but still the same issue persists.
              Hello Srinivas,
              Do u copy library at <home>/forms ?
              do you click yes for removing path when attaching ?

              Do you subclass webutil.olb in your forms ? If no check this link How to add object groups to a form ?


              Hope this works..

              Hamid
              • 4. Re: Error in Forms
                user2626293
                Hi Hamid,

                I have copied the entire library at <home>/forms.
                I have clicked yes for removing path when attaching the webutil.pll.
                I have sub classed webutil.olb in my form.

                But i am still getting the same error :(. Please help.

                I am running the form from my local system, is that a problem?

                Thanks and Regards
                Srinivas
                • 5. Re: Error in Forms
                  HamidHelal
                  user2626293 wrote:
                  Hi Hamid,

                  I have copied the entire library at <home>/forms.
                  I have clicked yes for removing path when attaching the webutil.pll.
                  I have sub classed webutil.olb in my form.
                  Hi Srinivas
                  But i am still getting the same error :(. Please help.
                  Open default.env file at forms/server folder.
                  add your library path at forms_path like,
                  assuming your all library are at <home>/forms folder, so add
                  <home>/forms
                  at FORMS_PATH
                  I am running the form from my local system, is that a problem?
                  No


                  Hope this helps
                  • 6. Re: Error in Forms
                    user2626293
                    Hi Hamid,

                    I have followed the steps below, but it gives me same error :(. Please help.

                    Thanks and Regards
                    Srinivas
                    • 7. Re: Error in Forms
                      CraigB
                      I have built a simple form based on the employee table and i have included a download button. Form compiles fine, but when i run the form i get the below error.
                      FRM-40039: Cannot attach library webutil while opening form EMP_DWNLD>
                      If you are going to run a form from the Forms Builder, you will have to modify the DEFAULT.ENV file and add the directory where your Library files exist to the FORMS_PATH entry. Additionally, I would add the directory where your forms exist to this path as well. This is where the runtime looks at the FORMS_PATH. Only the Forms Builder looks at the Registry FORMS_PATH.

                      Hope this helps,
                      Craig...
                      • 8. Re: Error in Forms
                        user2626293
                        Hi Craig,

                        Thanks for your response. I could get through the error of FRM-40039, i have done this by compiling the webutil.pll and generated the webutil.plx, and placed it in the same folder.

                        Now I am facing one more error :(:(:(. Now my form opens, but when i click on the download button it throws me the below error. Please advise.

                        "oracle.forms.webutil.ole.olefunctions bean not found"

                        Thanks and Regards
                        Srinivas
                        • 9. Re: Error in Forms
                          user2626293
                          Hi All,

                          Below are the contents in my Java Console, after error.

                          "webUtil Error: oracle.forms.webutil.ole.OleFunctions bean not found. CLIENT_OLE2.create_obj will not work"

                          "FRM-40735: WHEN BUTTON PRESSED trigger raised unhandled exception ORA-305500"

                          Oracle JInitiator: Version 1.3.1.22
                          Using JRE version 1.3.1.22-internal Java HotSpot(TM) Client VM
                          User home directory = C:\Documents and Settings\srinivas

                          Proxy Configuration: no proxy

                          JAR cache enabled
                          Location: C:\Documents and Settings\srinivas\Oracle Jar Cache
                          Maximum size: 50 MB
                          Compression level: 0



                          ----------------------------------------------------
                          c: clear console window
                          f: finalize objects on finalization queue
                          g: garbage collect
                          h: display this help message
                          l: dump classloader list
                          m: print memory usage
                          q: hide console
                          s: dump system properties
                          t: dump thread list
                          x: clear classloader cache
                          0-5: set trace level to <n>
                          ----------------------------------------------------

                          Loading http://d-184856:8889/forms/java/frmall_jinit.jar from JAR cache

                          proxyHost=null

                          proxyPort=0

                          connectMode=HTTP, native.

                          Forms Applet version is : 10.1.2.0

                          Please help.

                          Thanks and Regards
                          Srinivas
                          • 10. Re: Error in Forms
                            user2626293
                            Hi All,

                            Thanks for all your inputs, after reading different posts in the forums and trying all the valid possibilities, it has worked. Thank you everyone.

                            Thanks and Regards
                            Srinivas