Как удалить apex oracle

Обновлено: 07.07.2024

The APEX_APPLICATION package is a PL/SQL package that implements the Oracle Application Express rendering engine. You can use this package to take advantage of many global variables. Table 1-1 describes the global variables available in the APEX_APPLICATION package .

Table 1-1 Global Variables Available in APEX_APPLICATION

Specifies the currently logged in user.

Specifies the ID of the currently running application.

Specifies the ID of the currently running page.

Specifies the schema to parse for the currently running application.

Specifies the value of the request variable most recently passed to or set within the show or accept modules.

Refers to the web browser's current language preference.

Refers to whether debugging is currently switched on or off. Valid values for the DEBUG flag are 'Yes' or 'No'. Turning debug on shows details about application processing.

Refers to the home page of an application. The Application Express engine redirects to this location if no page is given and if no alternative page is dictated by the authentication scheme's logic.

Used to display a link to a login page for users that are not currently logged in.

Refers to the virtual path the web server uses to point to the images directory distributed with Oracle Application Express.

Refers to the owner of the Application Express schema.

Refers to whether the Application Express engine is running in print view mode. This setting can be referenced in conditions to eliminate elements not desired in a printed document from a page.

Refers to the application attribute 'Proxy Server'.

Refers to the current date on the database server. this uses the DATE DATATYPE.

Refers to the Oracle schema used to connect to the database through the database access descriptor (DAD).

Specifies the application's global notification attribute.

Referencing Arrays

Items are typically HTML form elements such as text fields, select lists, and check boxes. When you create a new form item using a wizard, the wizard uses a standard naming format. The naming format provides a handle so you can retrieve the value of the item later on.

To create your own items, you can access them after a page is submitted by referencing APEX_APPLICATION.G_F01 to APEX_APPLICATION.G_F50 arrays. You can create your own HTML form fields by providing the input parameters using the format F01 , F02 , F03 and so on. You can create up to 50 input parameters ranging from F01 to F50 , for example:

Because the F01 to F50 input items are declared as PL/SQL arrays, you can have multiple items named the same value. For example:

Note that following PL/SQL code produces the same HTML as show in the previous example.

Referencing Values Within an On Submit Process

You can reference the values posted by an HTML form using the PL/SQL variable APEX_APPLICATION . G_F01 to APEX_APPLICATION . G_F50 . Because this element is an array, you can reference values directly, for example:

Converting an Array to a Single Value

You can also use Oracle Application Express public utility functions to convert an array into a single value. The resulting string value is a colon-separated list of the array element values. For example:

This function enables you to reference G_F01 to G_F50 values in an application process that performs actions on data. The following sample process demonstrates how values are inserted into a table:

HELP Procedure

This function outputs page and item level help text as formatted HTML. You can also use it to customize how help information is displayed in your application.

Table 1-2 describes the parameters available in the HELP procedure.

Table 1-2 HELP Parameters

The application ID that contains the page or item level help you want to output.

The page ID that contains the page or item level help you want to display.

Flag to determine if item level help is output. If this parameter is supplied, the value must be either 'YES' or 'NO', if not the default value is 'YES'.

Flag to determine if region headers are output (for regions containing page items). If this parameter is supplied, the value must be either 'YES' or 'NO', if not the default value is 'YES'.

Use this parameter to include HTML between the page level help text and item level help text.

Use this parameter to include HTML at the bottom of the output, after all other help.

Use this parameter to include HTML before every region section. Note this parameter is ignored if p_show_regions is set to 'NO'.

Use this parameter to include HTML after every region section. Note this parameter is ignored if p_show_regions is set to 'NO'.

Use this parameter to include HTML before every item label for item level help. Note this parameter is ignored if p_show_item_help is set to 'NO'.

Use this parameter to include HTML after every item label for item level help. Note this parameter is ignored if p_show_item_help is set to 'NO'.

Use this parameter to include HTML before every item help text for item level help. Note this parameter is ignored if p_show_item_help is set to 'NO'.

Use this parameter to include HTML after every item help text for item level help. Note this parameter is ignored if p_show_item_help is set to 'NO'.

The following example shows how to use the APEX_APPLICATION.HELP procedure to customize how help information is displayed.

In this example, the p_flow_step_id parameter is set to :REQUEST , which means that a page ID specified in the REQUEST section of the URL controls which page's help information to display (see note after example for full details on how this can be achieved).

Also, the help display has been customized so that the region sub-header now has a different color (through the p_before_region_html parameter) and also the ':' has been removed that appeared by default after every item prompt (through the p_after_prompt_html parameter).

To implement this type of call in your application, you can do the following:

Create a page that will be your application help page.

Create a region of type 'PL/SQL Dynamic Content' and add the APEX_APPLICATION.HELP call as PL/SQL Source.

Then you can add a 'Navigation Bar' link to this page, ensuring that the REQUEST value set in the link is &APP_PAGE_ID .

STOP_APEX_ENGINE Procedure

This procedure raises the exception apex_application . e_stop_apex_engine internally. You must raise that exception again, if you use a WHEN OTHERS exception handler.

Learn about troubleshooting after failed installation.

In a successful installation the following banner displays near the end of the installation:

To reinstall, you must either drop the Oracle Application Express database schemas, or run a script to completely remove Application Express from the database, depending upon the installation type.

Topics:

A.4.1 Reverting to a Previous Release After a Failed Upgrade Installation

Learn about reverting to Oracle Application Express to a previous release in the case of a failed upgrade installation.

In the case of a failed upgrade installation, you may want to revert Oracle Application Express to a previous release and then remove the schemas associated with the current release.

Topics:

A.4.1.1 Verifying If You Have a Previous Release of Oracle Application Express

To verify, Start SQL*Plus and connect to the database and execute the command.

To verify whether you have a previous release of Application Express:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:

On UNIX and Linux:

If the query above returns any rows, the database contains a previous release of Oracle Application Express.

A.4.1.2 Reverting the Images Directory

Learn how to revert back to the release you want to revert to if you altered your images directory.

If you altered your images directory, revert it back to the release you want to revert to using the following methods:

For Oracle REST Data Services or mod_plsql :

If you altered your images directory, you must point the text alias /i/ back to images directory for the release you want to revert to.

For Embedded PL/SQL Gateway :

Run apex_epg_config.sql from the release directory you want to revert to, to restore the images of that release. See the Oracle Application Installation Guide for the release you want to revert to and find the section "Updating the Images Directory When Upgrading from a Previous Release."

A.4.1.3 Reverting to a Previous Release

Learn about reverting to Oracle Application Express prior release.

This section describes how to revert to a Oracle Application Express previous release.

Topics: