Global Variables

Global variables

Oracle allows the use of global variables defined in packages. Ora2Pg will export these variables for PostgreSQL as user-defined custom variables available in a session. Oracle variable assignments are exported as calls to:

PERFORM set_config('pkgname.varname', value, false);

Use of these variables in the code is replaced by:

current_setting('pkgname.varname')::global_variables_type;

where global_variables_type is the type of the variable extracted from the package definition.

If the variable is a constant or has a default value assigned at declaration, Ora2Pg will create a file global_variables.conf with the definition to include in the postgresql.conf file so that their values will already be set at database connection. Note that the value can always be modified by the user so you can not have exactly a constant.