The IN_LOGGER stored procedure is used to log certain actions to the IN_DB_UTIL_LOG table.
If the IN_DB_UTIL_LOG table does not exist then the IN_LOGGER stored procedure will attempt to create it.
Logged actions include recording calls to the following stored procedures:
- IN_SESSION_SET
- IN_SESSION_CLEAR
- IN_SESSION_CLEAR_ALL
- CLEANUP_AUDIT_DATA
- REBUILD_INDEXES
Logged actions also include recording any exceptions (errors) that occur within the IN_DB_UTIL and IN_DB_UPGRADE packages.
| Parameter | Description | |
|---|---|---|
| PROC_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | None | |
| Description | The name of the procedure or function that is logging the action. | |
| IDENTIFIER | Type: | OUTPUT |
| Datatype | VARCHAR2(128) | |
| Default Value: | IN_DB_UTIL | |
| Description | The identifier of the IN_CONTEXT namespace. | |
| Options |
IN_DB_UTIL SYNC UPGRADE |
|
| ERROR_MSG | Type: | INPUT |
| Datatype | VARCHAR2(4000) | |
| Default Value: | NULL | |
| Description | The error message that is being logged. | |
| SQL_CMD | Type: | INPUT |
| Datatype | VARCHAR2(4000) | |
| Default Value: | NULL | |
| Description | The SQL statement being logged. | |
EXCEPTIONS
Examples
IN_DB_UTIL.IN_LOGGER(V_PROC_NAME, V_IDENTIFIER, V_ERROR_MSG, V_EXEC_SQL);