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

DE_VARIABLESHARE

Default: unset

Valid Values: ON (UNIX), 1 (Windows)

Description: Allows global PL/SQL variables to be retained and shared between two or more Forms. For example, take two Forms that use the same library. In the first form, write the value into the package variable of the PLL. Open the second Form and read the value written by the first Form. The value is read. Now close the First form (the calling Form) and read the value from the second Form. The value is lost unless you set DE_VARIABLESHARE to ON in UNIX or 1 in the Windows Registry.

You can set the varaible either in the default.env ORACLE_HOME/forms/server or as an environment parameter:

export DE_VARIABLESHARE=1

For Windows:

  1. In Regedit, navigate to HKEY-LOCAL_MACHINE | Software | Oracle | Home0
  2. Right click New | String value | DE_VARIABLESHARE
  3. Double click the string and set the value 1.