12 Replies Latest reply: Mar 26, 2009 5:24 AM by Fabrizio Delli Priscoli RSS

    Webutil in Oracle 10.1.2.0.2

    Frank Enem
      Guys,

      I wanted to include Webutil in the forms and I have to read in Oracle white paper about webutil that from orcale 10g, webutil comes preconfigured with it.

      when I opened the webutil directory in forms, I found out that I only have four files namely: d2kwut60.dll, JNIsharedstubs.dll, sign_webutil and sign_webutil.sh. as against the various components listed.

      How can I get started by including the webutil files in my form to expose the various appliaction within the webutil.

      Thanks
        • 1. Re: Webutil in Oracle 10.1.2.0.2
          Fabrizio Delli Priscoli
          Have a look here:
          http://www.oracle.com/technology/products/forms/htdocs/webutil/WebUtilFAQ.htm

          And search around in the forum.
          You will find many posts about it.
          Hope it helps you,
          Fabrizio

          If this answer is helpful or correct, please mark it. Thanks.
          • 2. Re: Webutil in Oracle 10.1.2.0.2
            Frank Enem
            Thanks,

            My worry is that webutil.pll is not a component of the webutil directory in Oracle 10.1.2.0.2. Can I download webutil 1.0.6 and work with it?
            • 3. Re: Webutil in Oracle 10.1.2.0.2
              Fabrizio Delli Priscoli
              You will find webutil.pll file into your devsuite\form directory.
              Hope it helps you,
              Fabrizio
              • 4. Re: Webutil in Oracle 10.1.2.0.2
                Frank Enem
                Thanks,

                I have seen it but I was looking for it in webutil directory.

                I tried to compile and generate the library but it gave me the following errors

                -------error message
                Compilation errors on WEBUTIL_DB_LOCAL:
                PL/SQL ERROR 201 at line 9, column 12
                identifier 'WEBUTIL_DB.OPENBLOB' must be declared
                PL/SQL ERROR 0 at line 9, column 5
                Statement ignored
                PL/SQL ERROR 201 at line 18, column 12
                identifier 'WEBUTIL_DB.CLOSEBLOB' must be declared
                PL/SQL ERROR 0 at line 18, column 5
                Statement ignored
                PL/SQL ERROR 201 at line 24, column 5
                identifier 'WEBUTIL_DB.WRITEDATA' must be declared
                PL/SQL ERROR 0 at line 24, column 5
                Statement ignored
                PL/SQL ERROR 201 at line 29, column 12
                identifier 'WEBUTIL_DB.READDATA' must be declared
                PL/SQL ERROR 0 at line 29, column 5
                Statement ignored
                PL/SQL ERROR 201 at line 35, column 12
                identifier 'WEBUTIL_DB.GETLASTERROR' must be declared
                PL/SQL ERROR 0 at line 35, column 5
                Statement ignored
                PL/SQL ERROR 201 at line 40, column 12
                identifier 'WEBUTIL_DB.GETSOURCELENGTH' must be declared
                PL/SQL ERROR 0 at line 40, column 5
                Statement ignored
                PL/SQL ERROR 201 at line 45, column 12
                identifier 'WEBUTIL_DB.GETSOURCECHUNKS' must be declared
                PL/SQL ERROR 0 at line 45, column 5
                Statement ignored

                Failed to generate library.
                • 5. Re: Webutil in Oracle 10.1.2.0.2
                  Fabrizio Delli Priscoli
                  You must compile webutil_db package.
                  All is in the webutil documentation.
                  Fabrizio
                  • 6. Re: Webutil in Oracle 10.1.2.0.2
                    Frank Enem
                    Fabrizio

                    Pls just tell me the short cut and what to do here.

                    thanks
                    • 7. Re: Webutil in Oracle 10.1.2.0.2
                      Fabrizio Delli Priscoli
                      You must follow all steps in the documentation file to configure webutil.
                      Here is the webutil page:
                      http://www.oracle.com/technology/products/forms/htdocs/webutil/webutil.htm
                      And here is the documentation file:
                      http://www.oracle.com/technology/products/forms/htdocs/webutil/web_util.pdf
                      Fabrizio
                      • 8. Re: Webutil in Oracle 10.1.2.0.2
                        Frank Enem
                        Fabrizio,

                        Thanks so very much. I will get back to you with more queries 'morrow

                        Good nite.....

                        Francios.
                        • 9. Re: Webutil in Oracle 10.1.2.0.2 (Integrating Oracle Forms with Reports)
                          Frank Enem
                          Fabrizio,

                          I am having a problem integrating reports with forms.

                          When I run reports from forms, it gives me an error message <<Bind to report_server 'saver name' failed>> I did check the forum with this and get some suggestion on how to change the entries in the rwnetwork.conf


                          In rwnetwork.conf change
                          <?xml version="1.0" encoding="ISO-8859-1"?>
                          <!DOCTYPE discoveryService SYSTEM "file:/home/oas10g/frhome/reports/dtd/rwnetworkconf.dtd">
                          <discoveryService>

                          <namingService name="Cos" host="ICT50" port="14021"/>
                          </discoveryService>

                          I started the OC4J

                          I did run the namingservice.bat from c:\devsuitehome_1\BIN>namingservice.bat 14021
                          naming service started successfully

                          When I ran the appliaction again, it gave me internal server error.

                          500 Internal Server Error

                          java.lang.NullPointerException
                          at oracle.reports.rwclient.RWClient.doGet(RWClient.java:285)
                          at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
                          at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
                          at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).server.http.HttpRequestHandler.run(HttpRequestHandler.java:285)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).server.http.HttpRequestHandler.run(HttpRequestHandler.java:126)
                          at com.evermindhttp://Oracle Application Server Containers for J2EE 10g (10.1.2.0.2).util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
                          at java.lang.Thread.run(Thread.java:534)

                          I tried to edit the report by invoking the rwbuilder but it failed to opend. I reverted back to the initial entries in rwnetwork.conf and the rwbuilder started opening.

                          In all, I need help to get this resolved.
                          • 10. Re: Webutil in Oracle 10.1.2.0.2 (Integrating Oracle Forms with Reports)
                            Fabrizio Delli Priscoli
                            You can check in the report forum...
                            Fabrizio
                            • 11. Re: Webutil in Oracle 10.1.2.0.2 (Integrating Oracle Forms with Reports)
                              Frank Enem
                              Fabrizio,

                              I have battled with this now for more than two weeks in reports forum. If you have any suggestions, do not hesitate to render such suggestions.
                              • 12. Re: Webutil in Oracle 10.1.2.0.2 (Integrating Oracle Forms with Reports)
                                Fabrizio Delli Priscoli
                                Unfortunately I can't help you, because it is a long time that I don't use report..
                                Fabrizio