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);