The DBMS_SESSION package provides access to the ALTER SESSION SQL statement and other session information from PL/SQL. You can use DBMS_SESSION to set preferences and security levels.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Privilege requirements
You do not need the SYS privilege to call the DBMS_SESSION package.
Subprograms
The following table lists the subprograms of the DBMS_SESSION package in the current version of OceanBase Database and their descriptions.
| Subprogram | Description |
|---|---|
| CLEAR_ALL_CONTEXT | Clears all context information. |
| CLEAR_CONTEXT | Clears the specified context information. |
| CLEAR_IDENTIFIER | Clears the identifier. |
| RESET_PACKAGE | Clears all package variables in the session. |
| SET_CONTEXT | Sets or resets the value of a context attribute. |
| SESSION_IS_ROLE_ENABLED | Determines whether the specified role is enabled at the session level. |
| IS_ROLE_ENABLED | Determines whether the specified role is enabled in the session. |