Oracle9iAS Reports Services Publishing Reports to the Web
Release 9.0
Part Number A92102-01

B
Reports-Related Environment Variables

Environment variables are parameters that configure the environment that hosts Oracle9iAS Reports Services. The Oracle9iAS installer automatically defines default values for relevant environment variables. If you want something other than the default environment, you can edit the environment variable settings:

For Windows NT, edit environment variables through the Registry Editor (Start > Run > Regedit).
For UNIX, edit environment variables by revising and running the shell script that defines the initial default values (reports.sh). If you do this, be sure to keep a backup of the original, unaltered reports.sh file.

Table B-1 lists and describes the environment variables that pertain to Oracle9iAS Reports Services.

For more information on all NLS environment variables, see the Oracle9i Globalization Support Guide on the Oracle Technology Network (http://otn.oracle.com).

Table B-1 Environment variables relevant to Oracle9iAS Reports Services

Variable	Description
DEVELOPER_NLS_LANG	The language for the Oracle9iDS Reports Builder. Chapter 12, "NLS and Bidirectional Support" contains additional detailed information about this environment variable, including a table of valid values.
NLS_CALENDAR	The calendar system used.
NLS_CREDIT	The string used to indicate a positive monetary value.
NLS_CURRENCY	The local currency symbol.
NLS_DATE_FORMAT	The default format mask used for dates.
NLS_DATE_LANGUAGE	The default language used for dates.
NLS_DEBIT	The string used to indicate a negative memory value.
NLS_ISO_CURRENCY	The ISO currency symbol.
NLS_LANG	The language settings used by Oracle9iAS Reports Services. Chapter 12, "NLS and Bidirectional Support" contains additional detailed information about this environment variable, including a table of valid values.
NLS_LIST_SEPARATOR	The character used to separate items in a list.
NLS_MONETARY_CHARACTERS	The decimal character and thousands separator for monetary values.
NLS_NUMERIC_CHARACTERS	The decimal character and grouping separator for numeric values.
NLS_SORT	The type of sort used for character data.
REPORTS_COOKIE_EXPIRE	(rwcgi only) Determines the expire time of the cookie in minutes. The default value is 30. Cookies save encrypted user names and passwords on the client-side when users log on to a secured Oracle9iAS Reports Server to run report requests. When users successfully log on, their browser is sent an encrypted cookie. When a cookie expires, users must re-authenticate to run subsequent requests.
REPORTS_DB_AUTH	(rwcgi only) Specifies the database authentication template to be used for logging on to the database. The default value is `dbauth.htm`.
REPORTS_ENCRYPTION_KEY	(rwcgi only) Specifies the encryption key used to encrypt the user name and password for the cookie. The encryption key can be any character string. The default value is `reports9.0`.
REPORTS_CGIDIAGBODYTAGS	(rwcgi only) For the Oracle9iAS Reports CGI. Specifies HTML tags that are inserted as a <BODY...> tag in the RWCGI diagnostic and debugging output. For example, you might want to use this environment variable to set up text and background color or image. Reports CGI is maintained for backward compatibility only.
REPORTS_CGIDIAGHEADTAGS	(rwcgi only) For the Oracle9iAS Reports CGI. Specifies HTML tags to insert between <HEAD> ...</HEAD> tags in the RWCGI diagnostic and debugging output. For example, you might want to use this environment variable to set up <TITLE> or <META> tags. Reports CGI is maintained for backward compatibility only.
REPORTS_CGIHELP	(rwcgi only) For the Oracle9iAS Reports CGI. Defines URL and URI of the RWCGI help file that should display when RWCGI is invoked with the following empty request: `http://<your_webserver>/RWCGI90?` For example, setting it to `http://www.yahoo.com` goes to that URL; setting it to `myhelpfile.htm` displays the following file: `http://<your_webserver>/myhelpfile.htm` If this parameter is not defined, then a default help screen is displayed. Reports CGI is maintained for backward compatibility only.
REPORTS_CGIMAP	(rwcgi only) For the Oracle9iAS Reports CGI. Defines fully qualified file name and location of the RWCGI map file if map file configuration is used. For example: `ORACLE_HOME\reports\conf\cgicmd.dat` Reports CGI is maintained for backward compatibility only.
REPORTS_CGINODIAG	(rwcgi only) Set to YES or NO. For the Oracle9iAS Reports CGI. When defined, disables all debugging and diagnostic output, such as help and showmap, from RWCGI. For example, the following request does not work when REPORTS_CGINODIAG is defined: `http://<``your_webserver``>/rwcgi/help?` Reports CGI is maintained for backward compatibility only.
REPORTS_PATH	Specifies the directories in which Reports components will automatically search for any files they require. Separate directories with semicolons or colons, depending upon the platform. If you specify a path for the sourceDir attribute of the engine element in the Reports Server configuration file (`<``server_name``>.conf`), the sourceDir value will override the values you set here.
REPORTS_SERVER	(rwcgi only) Specifies the default Oracle9iAS Reports Server. When this environment variable is set, you can omit the SERVER command line argument in report requests if you want to process them with the default server. Conversely, you can include the SERVER command line argument to override the default you specify here.
REPORTS_SSLPORT	(rwcgi only) If you are using SSL and you want to use a port number other than 443, then you can use this variable to set a different port number.The default value is 443.
REPORTS_SYS_AUTH	(rwcgi only) Specifies the authentication template for displaying the user name and password request dialog when users run report request to a restricted Oracle9iAS Reports Server.
REPORTS_TMP	Specifies the temporary directory where Reports development- and server-related temporary files will automatically (and temporarily) be stored.
RW	Specifies the reports-specific directory within the Oracle Home. For example: Windows: `RW=d:\``ORACLE_HOME``\reports` UNIX: `RW=``ORACLE_HOME``/reports`
USER_NLS_LANG	The language for the Oracle9iAS Reports Runtime component. Chapter 12, "NLS and Bidirectional Support" contains additional detailed information about this environment variable, including a table of valid values.

Oracle

Copyright © 2002 Oracle Corporation.
All Rights Reserved.