The following table contains a list of the database objects that comprise the IN_DB_UTIL package which are created when the script above is executed.
| Object Name | Object Type | Scope |
|---|---|---|
| IN_CONTEXT | Application Context | Global |
| IN_CONTEXT_ATTR | Record Type | Framework |
| IN_CONTEXT_ATTRIBUTES | Table Type | Framework |
| IN_OBJECTS | Record Type | Framework |
| IN_OBJECT_DDL | Table Type | Framework |
| IN_PARAMETERS | Record Type | Framework |
| IN_PARAMETERS_VALUES | Nestled Table Type | Framework |
| IN_CALLSTACK | Record Type | Framework |
| IN_CALLSTACK_TABLE | Nestled Table Type | Framework |
| IN_IDENTIFIER_TABLE | Associative Array | Framework |
| IN_DB_UTIL_LOG | Table | Framework |
| IN_CALLSTACK_EXTEND | Stored Procedure | Framework |
| IN_CALLSTACK_TRIM | Stored Procedure | Framework |
| IN_CALLSTACK_PRINT | Stored Procedure | Framework |
| IN_CALLSTACK_GET_HIST | Stored Procedure | Framework |
| IN_CONTEXT_SET | Stored Procedure | Framework |
| IN_CONTEXT_CLEAR | Stored Procedure | Framework |
| IN_CONTEXT_GET | Function | Framework |
| IN_CONTEXT_PRINT | Stored Procedure | Framework |
| IN_SESSION_SET | Stored Procedure | Framework |
| IN_SESSION_CLEAR | Stored Procedure | Framework |
| IN_SESSION_CLEAR_ALL | Stored Procedure | Framework |
| IN_LOGGER | Stored Procedure | Framework |
| CLEAR_VARIABLES | Stored Procedure | Framework |
| EXECUTE_DML | Stored Procedure | Framework |
| PRINT_SQL | Stored Procedure | Framework |
| CHECK_PARAMETER | Stored Procedure | Framework |
| CHECK_TIME | Function | Framework |
| GET_IN_DB_UTIL_VERSION | Function | Framework Metadata |
| GET_IN_DB_SCHEMA_VERSION | Function | Schema Metadata |
| PARSE_SCHEMA_VERSION | Stored Procedure | Schema Metadata |
| PRINT_SCHEMA_HIST | Stored Procedure | Schema Metadata |
| PRINT_INDEX_DDL | Stored Procedure | Schema Metadata |
| PRINT_FK | Stored Procedure | Schema Metadata |
| GET_FK_DDL | Stored Procedure | Schema Metadata |
| DROP_INDEX | Stored Procedure | Schema Change |
| DROP_PK | Stored Procedure | Schema Change |
| DROP_FK | Stored Procedure | Schema Change |
| DISABLE_FK | Stored Procedure | Schema Change |
| ENABLE_FK | Stored Procedure | Schema Change |
| RENAME_OBJECT | Stored Procedure | Schema Change |
| RENAME_CONSTRAINT | Stored Procedure | Schema Change |
| GET_DB_INFO | Stored Procedure | Database Information |
| GET_CPU_COUNT | Function | Database Information |
| GET_DB_CONNECTIONS | Stored Procedure | Database Check |
| GET_DB_CONNECTIONS_COUNT | Function | Database Check |
| SET_NLS_SESSION_PARAMETERS | Stored Procedure | Session |
| SET_DBA_ROLE | Stored Procedure | Session |
| SET_PARALLEL | Stored Procedure | Session |
| DISABLE_PARALLEL | Stored Procedure | Session |
| TRACE_SESSION | Stored Procedure | Session |
| GET_SECONDS | Stored Procedure | Metrics |
| GET_DURATION | Stored Procedure | Metrics |
| GET_RPM | Stored Procedure | Metrics |
| CLEANUP_AUDIT_DATA | Stored Procedure | Maintenance |
| REBUILD_INDEXES | Stored Procedure | Maintenance |