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-compatible mode.
DBMS_UTILITY data structures
The DBMS_UTILITY package defines the following RECORD and TABLE types.
/*RECORD type*/
TYPE INSTANCE_RECORD IS RECORD (
INST_NUMBER NUMBER,
INST_NAME VARCHAR2(60));
/*TABLE type*/
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. |
| EXEC_DDL_STATEMENT | Executes the specified DDL statement. |
| 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. |