SET_SCHEMA Procedure

This function is used to set the parsing schema ("owner") of the Application Express application. The database user of this schema must already exist, and this schema name must already be mapped to the workspace which will be used to import the application.

Syntax

APEX_APPLICATION_INSTALL.SET_SCHEMA (
    p_schema  IN VARCHAR2);

Parameters

Table: SET_SCHEMA Parameters describes the parameters available in the SET_SCHEMA procedure.

SET_SCHEMA Parameters

Parameter	Description
`p_schema`	The schema name.

Example

For examples of this procedure call, see "Import Application into Different Workspace using Different Schema" and "Import into Training Instance for Three Different Workspaces".