39.119 SET_PARSING_SCHEMA_FOR _REQUEST Procedure

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

PROCEDURE SET_PARSING_SCHEMA_FOR_REQUEST (
    p_schema IN VARCHAR2 );

Parameters

Table 39-103 SET_PARSING_SCHEMA_FOR _REQUEST Parameters

Parameter	Description
p_schema	The new parsing schema.

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;