The DBMS_UTILITY package provides utility procedures.
Notice
The DBMS_UTILITY package in the current version of OceanBase Database does not support passing parameters in UTF16 encoding.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
DBMS_UTILITY data structures
The DBMS_UTILITY system package defines the following RECORD and TABLE types.
/*RECORD types*/
TYPE INSTANCE_RECORD IS RECORD (
INST_NUMBER NUMBER,
INST_NAME VARCHAR2(60));
/*TABLE types*/
TYPE UNCL_ARRAY IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
TYPE NAME_ARRAY IS TABLE OF VARCHAR2(128) INDEX BY BINARY_INTEGER;
TYPE QUOTED_NAME_ARRAY IS TABLE OF VARCHAR2(130) INDEX BY BINARY_INTEGER;
TYPE LNAME_ARRAY IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
TYPE MAXNAME_ARRAY IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
TYPE DBLINK_ARRAY IS TABLE OF VARCHAR2(128) INDEX BY BINARY_INTEGER;
TYPE INDEX_TABLE_TYPE IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
TYPE NUMBER_ARRAY IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
TYPE INSTANCE_TABLE IS TABLE OF INSTANCE_RECORD INDEX BY BINARY_INTEGER;
DBMS_UTILITY subprograms
The following table lists the DBMS_UTILITY subprograms supported in the current OceanBase Database version and their brief descriptions.
| Subprogram | Description |
|---|---|
| ACTIVE_INSTANCES | Returns the active instances. |
| CURRENT_INSTANCE | Returns the instance number of the current connection. |
| DB_VERSION | Returns the database version information. |
| FORMAT_CALL_STACK | Formats the current call stack. |
| FORMAT_ERROR_BACKTRACE | Formats the backtrace of the call stack that triggered the exception. |
| FORMAT_ERROR_STACK | Formats the current error stack. |
| GET_ENDIANNESS | Gets the byte storage order of the database platform. |
| GET_HASH_VALUE | Calculates the hash value of the given string. |
| GET_PARAMETER_VALUE | Gets the value of the specified init.ora parameter. |
| GET_SQL_HASH | Calculates the hash value of the specified string using the MD5 algorithm. |
| GET_TIME | Returns the current time in units of 100 seconds. |
| IS_BIT_SET | Checks whether the specified bit in the RAW value is set. |
| IS_CLUSTER_DATABASE | Determines whether the database is running in cluster database mode. |
| NAME_RESOLVE | Resolves the specified name. |
| NAME_TOKENIZE | Calls the parser to resolve the specified name. |
| OLD_CURRENT_SCHEMA | Returns the session value from SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA'). |
| OLD_CURRENT_USER | Returns the session value from SYS_CONTEXT ('USERENV', 'CURRENT_USER'). |
| PORT_STRING | Returns a string that uniquely identifies the database version and operating system. |
| TABLE_TO_COMMA | Converts a PL/SQL name table into a comma-separated list of names. |
| COMMA_TO_TABLE | Converts a comma-separated string into a PL/SQL table. |
| VALIDATE | Validates or recompiles the validity of a single database object. |