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.
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 |
|
Web server running the CGI scripts. |
|
Web server listener port. |
|
Required for secured server only. |
|
Starts a Web server installed on the Windows operating system. |
|
Starts a Web server installed on any UNIX operating system. |
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=cache
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
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=printer+desname=myprinter
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”
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”
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
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=myxmlpdstest.rdf+destype=file+desformat=PDF+desname=c:\mydir\my.pdf
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
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+distribute=yes+destination=c:\mydistribute.xml
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
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
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
http://mywebserver.com:7779/cgi-bin/rwcgi.exe?server=myrepserver+report=test.rdf+userid=scott/tiger@mydb+destype=cache+desformat=htmlcss+paramform=yes
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
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"
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
Running a report from the command line
Copyright © 1984, 2005, Oracle. All rights reserved.