Oracle Report Request Methods

You can run report requests using various request methods, described below:

The RWCLI60 command line enables you to run a report request from the command line prompt. RWCLI60 is an executable file that parses and transfers the command line to the specified Oracle Reports Server. It uses a command line similar to the Oracle Reports Runtime executable file (RWRUN60). An RWCLI60 command line request is made using a non-Web architecture.

A typical command line request looks like the following:

syntax

RWCLI60 REPORT=my_report.rdf USERID=username/password@my_db SERVER=repserver DESTYPE=HTML DESFORMAT=cache

The URL syntax enables you to run a report request from a Web browser. The CGI and servlet converts the URL syntax into an RWCLI60 command line request that is processed by Oracle Reports Services. When the report has finished processing, the output is sent to an HTML or PDF file in a location known to the Web server, which is served back to the requesting Web browser. You can provide users the URL syntax needed to make the report request from their browser, or you can add the URL syntax to a Web site as a hyperlink.

The Oracle WebDB component enables you to add a link as an Oracle WebDB component to an Oracle WebDB site. This link points to a packaged procedure that contains information about the report request. Oracle Reports Services system administrators use Oracle WebDB wizards to create the packaged procedure making it more convenient and secure to publish the report via the Web. Authorized users accessing the Oracle WebDB site simply click the link to run the report. System administrators can run the report directly from the wizard.

ActiveX control exposes Oracle Reports Services through industry-standard ActiveX technology enabling you to run reports from any ActiveX container. The Oracle Reports Launcher is an example of an ActiveX container.

The SRW.RUN_REPORT is a packaged PL/SQL procedure that runs an Oracle Reports Runtime command. When you specify the SRW.RUN_REPORT command line, set the SERVER argument to Oracle Reports Services TNS service entry name to cause the SRW.RUN.REPORT command to behave as though you executed an RWCLI60 command. For more information on RUN_REPORT view the following blog post.

Oracle Apps