This discussion is archived
12 Replies Latest reply: Mar 26, 2009 3:24 AM by Fabrizio Delli Priscoli RSS

Webutil in Oracle 10.1.2.0.2

Frank Enem Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    Unfortunately I can't help you, because it is a long time that I don't use report..
    Fabrizio

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points