The DBMS_SESSION system package provides access to ALTER SESSION SQL statements and other session information from PL. You can use DBMS_SESSION to set preferences and security levels.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
DBMS_SESSION Privilege Description
The DBMS_SESSION system package calls user privileges, and does not require SYS privileges.
Overview of DBMS_SESSION Subprograms
The following table lists the DBMS_SESSION subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| CLEAR_ALL_CONTEXT | Clears all context information. |
| CLEAR_CONTEXT | Clears the specified context information. |
| CLEAR_IDENTIFIER | Clear the identifier. |
| RESET_PACKAGE | Clears all package variables from the session. |
| SET_CONTEXT | Sets or resets the value of a context property. |
| SET_IDENTIFIER | Set the identifier. |