The IN_DB_UTIL_SP_LOGGER stored procedure is used to log specified actions to the IN_DB_UTIL_LOG table. This procedure is executed by many other stored procedures to log qualifying actions such as setting up a session (IN_DB_UTIL_SP_SESSION_SETUP) or tearing down a session (IN_DB_UTIL_SP_CLEAR_IDENTIFIER) or to log any errors that are encountered.
| Parameter | Description | |
|---|---|---|
| PROC_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Can be used to pass in a procedure name or some other application name to be associated with the logged record. | |
| IDENTIFIER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Can be used to pass in a NULL or valid identifier. For valid identifiers other than NULL then additional session attributes associated with the identifier will be fetched and logged. | |
| Options |
NULL | IN_DB_UTIL | ALL | UPGRADE | SYNC |
|
| INFO_MSG | Type: | INPUT |
| Datatype: | NVARCHAR(MAX) | |
| Default Value: | NULL | |
| Description | Can be used to pass in an information message to be logged. | |
| ERROR_MSG | Type: | INPUT |
| Datatype: | NVARCHAR(MAX) | |
| Default Value: | NULL | |
| Description | Can be used to pass in an error number and/or error message to be logged. | |
| SQL_CMD | Type: | INPUT |
| Datatype: | NVARCHAR(MAX) | |
| Default Value: | NULL | |
| Description | Can be used to pass in an SQL statement or other command to be logged. | |
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display available debugging information | |
| Option | YES = Display debug information. NO = Do not display debug information. |
|
Example
-- To log a record to the IN_DB_UTIL_LOG table EXEC IN_LOGGER @PROC_NAME, @IDENTIFIER, @INFO_MSG, @ERROR_MSG, @SQL_CMD, @DEBUG; -- To view the contents of the IN_DB_UTIL_LOG table SELECT * FROM IN_DB_UTIL_LOG ORDER BY LOG_ID;