SET_PARSING_SCHEMA Procedure

5.27 SET_PARSING_SCHEMA Procedure

This procedure sets the parsing schema ("owner") of an application.

The database user of the schema must already exist and the schema name must already be mapped to the workspace.

Syntax

APEX_APPLICATION_ADMIN.SET_PARSING_SCHEMA (
    p_application_id IN NUMBER,
    p_schema         IN VARCHAR2 )

Parameters

Parameter	Description
`p_application_id`	The application ID.
`p_schema`	The schema name.

Example

The following example sets the parsing schema to "EXAMPLE" for application 100.

BEGIN
    apex_application_admin.set_parsing_schema (
        p_application_id => 100,
        p_schema         => 'EXAMPLE' );
END;