Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
OLAP_API_SESSION_INIT , 5 of 7
This procedure removes a previously defined ALTER SESSION
parameter for OLAP API users with a particular database role. It deletes a row from the OLAP$ALTER_SESSION
table.
DELETE_ALTER_SESSION ( role_name IN VARCHAR2, session_parameter IN VARCHAR2);
The role_name
and session_parameter
together uniquely identify a row in OLAP$ALTER_SESSION
.
Parameter | Description |
---|---|
|
The name of a valid role in the database. Required. |
|
A parameter that can be set with a SQL |
Exception | Description |
---|---|
|
Role is not defined in the database. |
|
Session parameter has already been set for that role. |
The following call deletes a row in OLAP$ALTER_SESSION
that contains a value of OLAP_DBA
in the first column and QUERY_REWRITE_ENABLED=TRUE
in the second column.
call olap_api_session_init.delete_alter_session( 'OLAP_DBA', 'SET QUERY_REWRITE_ENABLED=TRUE');
|
![]() Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|