IN_LOGGER - Perceptive Content Database IN_DB_UTIL Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database IN_DB_UTIL Package for Oracle Server

Platform
Perceptive Content
Product
Perceptive Content Database IN_DB_UTIL Package for Oracle Server
Release
Foundation 24.1
License

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