ADD_ALTER_SESSION Procedure

This procedure specifies an ALTER SESSION parameter for OLAP API users with a particular database role. It adds a row to the OLAP$ALTER_SESSION table.

Syntax

ADD_ALTER_SESSION (
     role_name           IN     VARCHAR2,
     session_parameter   IN     VARCHAR2);

Parameters

The role_name and session_parameter are added as a row in OLAP$ALTER_SESSION.

Table 8-2  ADD_ALTER_SESSION Procedure Parameters

Parameter	Description
role_name	The name of a valid role in the database. Required.
session_parameter	A parameter that can be set with a SQL ALTER SESSION command. Required.

Exceptions

Table 8-3  ADD_ALTER_SESSION Procedure Exceptions

Exception	Description
invalid_role	Role is not defined in the database.
duplicate_role	Session parameter has already been set for that role.

Examples

The following call inserts a row in OLAP$ALTER_SESSION that turns on query rewrite for users with the OLAP_DBA role.

call olap_api_session_init.add_alter_session(
     'OLAP_DBA', 'SET QUERY_REWRITE_ENABLED=TRUE');

The ALL_OLAP_ALTER_SESSION view now contains the following row:

OLAP_DBA

ALTER SESSION SET QUERY_REWRITE_ENABLED=TRUE