This procedure changes the parsing user for the current page view to another workspace schema. You can call this procedure only from within the application's Initialization PL/SQL Code.

Syntax

APEX_UTIL.SET_PARSING_SCHEMA_FOR_REQUEST (
    p_schema IN VARCHAR2 );

Parameters

Raises

PROGRAM_ERROR when not called from Initialization PL/SQL Code. WWV_FLOW.NO_PRIV_ON_SCHEMA if p_schema is not a valid workspace schema.

Example

On pages 1-100, change the parsing schema to :G_PARSING_SCHEMA.

IF :APP_PAGE_ID between 1 and 100 THEN
    apex_util.set_parsing_schema_for_request (
       p_schema => :G_PARSING_SCHEMA );
END IF;