58.136 SET_SESSION_TERRITORY Procedure
This procedure sets the territory to be used for the current user in the current Oracle APEX session. The territory name must be a valid Oracle territory.
Syntax
APEX_UTIL.SET_SESSION_TERRITORY (
p_territory IN VARCHAR2 );
Parameters
Table 58-98 SET_SESSION_TERRITORY Parameters
Parameter | Description |
---|---|
p_territory |
A valid Oracle territory name. Examples include: AMERICA , UNITED KINGDOM , ISRAEL , AUSTRIA , and UNITED ARAB EMIRATES .
|
Example
The following example shows how to use the SET_SESSION_TERRITORY
procedure. It sets the territory for the current user for the duration of the APEX session.
BEGIN
APEX_UTIL.SET_SESSION_TERRITORY( P_TERRITORY => 'UNITED KINGDOM');
END;
Parent topic: APEX_UTIL