Databases Reference
In-Depth Information
The list of CGI variables in Figure
14-2
is only available to workspace administrators. If developers need to see a
complete list of CGI variables and their values, they can create a PL/SQL region and use
OWA_UTIL.PRINT_CGI_ENV
as
the region source.
■
You can only obtain Cgi variables from a web interface because they're web-based variables. if developers try
to query them in sQL*plus, they don't get any results. The following article contains more information on Cgi variables:
Note
Checking the APEX Version
The About Application Express page displays the current version of APEX. You can also obtain the version using the
following query:
SELECT *
FROM apex_release
Obtaining the APEX version from a query can be important for DBAs when upgrading an application. Also,
developers sometimes write code that is dependent on the current version of APEX.
Managing the Service
Click the Manage Service icon to change preferences and other settings affecting the operation of your APEX service.
You find the Manage Service icon on the Administration home page shown in Figure
14-1
.
Figure
14-3
shows the main Manage Service page.
Figure 14-3.
Manage Service page
