36.112 SET_EDITION Procedure

This procedure sets the name of the edition to be used in all application SQL parsed in the current page view or page submission.

Syntax

APEX_UTIL.SET_EDITION(
    p_edition IN VARCHAR2);

Parameters

Table 36-96 SET_EDITION Parameters

Parameter	Description
p_edition	Edition name.

Example

The following example shows how to use the SET_EDITION procedure. It sets the edition name for the database session of the current page view.

BEGIN
    APEX_UTIL.SET_EDITION( P_EDITION => 'Edition1' );
END;

Note:

Support for Edition-Based Redefinition is only available in database version 11.2.0.1 or higher.