A script-enabled browser is required for this page to function properly.

rwcgi

Like rwservlet, rwcgi (the Common Gateway Interface (CGI)) translates and delivers information between a Web server or and the Reports Server, enabling you to run a report dynamically from your Web browser.

Note: With Oracle Reports 10g, rwcgi is deprecated (maintained only for backward compatibility); instead, use JSPs, Reports Servlet (rwservlet), or Web Services.

rwservlet is strongly recommended over rwcgi for performance reasons. For each request, rwcgi starts a new process, initializing a JVM and resulting in slow performance when running a large number of report requests. On the other hand, rwservlet is deployed on an OC4J instance and leverages servlet functionality, thereby providing better performance over rwcgi.

The keywords that can be used with rwcgi are:

ACCESSIBLE
ARRAYSIZE
AUTHID
AUTOCOMMIT
BACKGROUND
BCC
BLANKPAGES
BUFFERS
CACHELOB
CC
CELLWRAPPER
COLLATE
CONTAINSHTMLTAGS
CONTAINSOLE
CONTENTAREA*
COPIES
CUSTOMIZE
DATEFORMATMASK
DELAUTH
DELIMITED_HDR
DELIMITER
DESFORMAT
DESNAME
DESTINATION
DESTYPE
DISTRIBUTE
ENGINERESPONSETIMEOUT
ENVID
EXPIRATION
EXPIREDAYS
EXPRESS_SERVER
FROM
GETJOBID
HELP
ITEMTITLE
JOBNAME
JOBTYPE
KILLJOBID
LONGCHUNK
MIMETYPE
MODE
MODULE|REPORT
NONBLOCKSQL
NOTIFYFAILURE
NOTIFYSUCCESS
NUMBERFORMATMASK
OLAP_CON
ONFAILURE
ONSUCCESS
ORIENTATION
OUTPUTFOLDER*
OUTPUTIMAGEFORMAT
OUTPUTPAGE
PAGEGROUP
PAGESIZE
PAGESTREAM
PARAMFORM
PARSEQUERY
PDFCOMP
PDFEMBED
READONLY
RECURSIVE_LOAD
REPLYTO
REPORT|MODULE
ROLE
RUNDEBUG
SCHEDULE
SERVER
SHOWAUTH
SHOWENV
SHOWJOBS
SHOWMAP
SHOWMYJOBS
SITENAME*
SQLTRACE
STATUSFOLDER*
STATUSPAGE
SUBJECT
SUPPRESSLAYOUT
TOLERANCE
TRACEOPTS
URLPARAMETER
USERID
USERSTYLES

* maintained for backward compatibility with Oracle9iAS Portal Release 1 and Oracle WebDB Release 2.2.

Examples

Note: Bold items identify elements specific to rwcgi requests

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=myrepo.rdf+desname=sample.pdf+desformat=pdf+destype=file 
http://mywebserver.com:7779/cgi-bin/rwcgi.sh?server=myrepserver+authid=myrepuser/myreppassword+report=myrepo.rdf+desname=sample.pdf+desformat=pdf+destype=file

Value

Description

mywebserver.com

Web server running the CGI scripts.

7779
Web server listener port.
authid
Required for secured server only.
rwcgi.exe
Starts a Web server installed on the Windows operating system.
rwcgi.sh
Starts a Web server installed on any UNIX operating system.

Example 1: Running a paper report to a browser (cache)

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=cache

Example 2: Sending report output to a file

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=c:\mydir\test

Example 3: Sending report output to a printer

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=printer+desname=myprinter

Example 4: Sending report output to e-mail

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=mail+desname=emp1@comp.com, emp2@comp.com+cc=emp3@comp.com+bcc=mgr@comp.com+replyto=me@comp.com+from=me@comp.com”

Example 5: Sending report output to WebDAV (any WebDAV server or OracleAS Portal WebDAV)

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=htmlcss+destype=webdav+desname=http://myusername:mypassword@mywebdavserv.com/mydir/test.html”

Example 6: Sending report output to OracleAS Portal

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+destype=oracleportal+desformat=PDF+pagegroup=mypagegrp+outputpage=reports_output+itemtitle=pushtoportal+statuspage=result

Example 7: Sending XML PDS report output to a file

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=myxmlpdstest.rdf+destype=file+desformat=PDF+desname=c:\mydir\my.pdf

Example 8: Sending JDBC PDS report output to a file

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=myjdbcpdstest.rdf+destype=file+desformat=PDF+desname=c:\mydir\myxml.pdf+p_jdbcpds=sybuser/sybpwd@server1.mydomain.com:1300

Example 9: Distributing report output to multiple destinations

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+distribute=yes+destination=c:\mydistribute.xml

Example 10: Running scheduled reports

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf+schedule=every first fri of month from 15:53 Oct 23, 1999 retry 3 after 1 hour”+destype=file+desformat=pdf+desname=test.pdf

Example 11: Using a secured Reports Server

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=file+desname=test.pdf+authid=myadmin/myadmin

Example 12: Using a key file

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?key1

where key1=key defined in the cgicmd.dat file (the keyname should be the first parameter)

or

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+userparam=12+cmdkey=key1

*when used with cmdkey, it can be anywhere in the URL

Example 13: Running a report with a Parameter Form

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=cache+desformat=htmlcss+paramform=yes

Example 14: Running a report with e-mail notification

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+notifysuccess=emp@comp.com+notifyfailure=admin@comp.com

Example 15: Running a report that specifies a URL to be fetched with the URL engine

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+jobType=rwurl+urlParameter="http://www.oracle.com"

Example 16: Running a report with tracing enabled

http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=file+desformat=pdf+desname=test.pdf+traceopts=trace_prf

See also

rwbuilder

rwrun

rwclient

rwserver

rwservlet

rwconverter

rwbridge

Command line keywords

Using the command line

Running a report from the command line