My Oracle Support Banner

Dynamic Environment Switching in Oracle Reports (Doc ID 231051.1)

Last updated on JANUARY 17, 2024

Applies to:

Oracle Reports Developer - Version to [Release 9i to 12.2]
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


The purpose of this article is to document and demonstrate how Oracle Reports can dynamically use different environment variables, without having to have a separate Reports Server for each set of environment variables.

Dynamically Setting Reports Environment Variables.

Previously, when the Reports Server was started it read the registry (Windows) or current environment variables (Unix) and any reports executed via the Reports Server would use these. Therefore, when you wanted to set two different values for an environment variable (like REPORTS_PATH) and use a specific setting at runtime, this could not be achieved. For example, a developer might want to use one Reports Server but have the REPORTS_PATH pointing to a 'Development Area' and a 'Test Area'. This meant you had to have multiple Reports Servers running for each setting, which can be costly in terms of administration.

However, starting from Oracle Reports 10g 'Dynamic Environment Switching' has been implemented so you can use one Reports Server, but override certain current settings by using a configuration file.


This article is written for Developers and DBA's alike, or anyone that has an interest in Web Reports.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.