webutil usage

Posted on 2007-10-09
Last Modified: 2013-12-19
Can I use webutil if I am using developer 9, oracle iAS 9i and oracle database ??????

I have created a csv file on my application server ( iAS 9i ) and I asked how to show or let the users see or save the file in order to manipulate it, both times experts recommended to use webutil, but I have readen the document and it says it can be used on 10g.

I just use the open/close file and the put line in order to create my document.

Please assist, this is urgent.

Thanks in advance
Question by:dyanuca
    LVL 22

    Expert Comment

    WEBUTIL on 9i can be used though it is not supported by Oracle. It means that if there are some troubles (bugs) Oracle support team cannot fix it.
    WEBUTIL was developed for forms 9i and is fully supported from Oracle since 10g.
    LVL 47

    Accepted Solution

    WEBUTIL is a good tool and has many good features.

    But for your not so complex task you cam use a workaround.
    Invoke from Forms a Report and use the DELIMITED or
    DELIMITEDDATA as destination format.  Then simply
    save the Report on the local machine and Import it in the
    Excel (possibly the delimiter is Tab character).

    Author Comment

    Hi schewertner,

    I  tried the solution you recommended (using the delimited and delimiteddata as destype), but for some reason I got problems while showing the report. That is why I tried the webutil.

    Can you please provide me more guidance on this? if you have any examples or how to set the parameters as destype, desformat, etc would be great.

    Also those parameters needs to be set on reports and forms, right?
    LVL 47

    Expert Comment

    What kind of problems?

    In Forms you can invole Reports by two ways

    1. Use On-line help and search 'Report Built-ins'
       There is a plenty of builins, pay attention to COPY_REPORT_OBJECT_OUTPUT
       Other are also good
    2. Builtin WEB.SHOW_DOCUMENT

    To invoke a Report you can use the URL like this:

    http://machine_name/reports/rwservlet?module=prescriptions.rdf+destype=cache+desformat=delimiteddata+userid=user/passw@alias+.... here parameter values

    Alternativelly you can try the package client_Input_io of WEBUTIL that can produce text files
    on the client side.
    The bad news is that everything needs many days of experiments and tests before
    it runs OK!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now