The DBMS_SESSION package provides access to the ALTER SESSION SQL statement and other session information from PL. You can use the DBMS_SESSION package to set preferences and security levels.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Privileges
This DBMS_SESSION package runs with the privileges of the calling user, rather than that of the SYS user.
Subprograms
The following table describes the DBMS_SESSION subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| CLEAR_ALL_CONTEXT | Clears all context information. |
| CLEAR_CONTEXT | Clears specified context information. |
| CLEAR_IDENTIFIER | Clears an identifier. |
| RESET_PACKAGE | Clears all package variables in a session. |
| SET_CONTEXT | Sets or resets the value of the context attribute. |
| SET_IDENTIFIER | Sets an identifier. |