The DBMS_UTILITY package provides utility procedures.
Notice
Currently, the DBMS_UTILITY package of OceanBase Database does not support passing parameters using 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 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;
Subprograms of DBMS_UTILITY
The following table describes the DBMS_UTILITY subprograms supported in OceanBase Database and their functions.
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 caused 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 a given string. |
| GET_PARAMETER_VALUE | Gets the value of a specified init.ora parameter. |
| GET_SQL_HASH | Calculates the hash value of a specified string using the MD5 algorithm. |
| GET_TIME | Returns the current time in units of 100 seconds. |
| IS_BIT_SET | Checks whether a specified bit in a RAW value is set. |
| IS_CLUSTER_DATABASE | Determines whether the database is running in cluster database mode. |
| NAME_RESOLVE | Resolves a specified name. |
| NAME_TOKENIZE | Calls the parser to resolve a 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. |