The IN_CONTEXT_PRINT and IN_CALLSTACK_PRINT procedures can be used to view context attribute values and call stack details if needed for troubleshooting. For more detailed troubleshooting information you can enable DEBUG mode when compiling the package.
- To view active session details for the SYNC and UPGRADE identifiers, execute the following
command.
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT
- To view active session details for the IN_DB_UTIL identifier, execute the following command. EXEC IN_DB_UTIL.IN_CONTEXT_PRINT('IN_DB_UTIL');
- To view call stack details for the SYNC and UPGRADE identifiers, execute the following command. EXEC IN_DB_UTIL.IN_CALLSTACK_PRINT;
- To view call stack details for the IN_DB_UTIL identifier, execute the following command. EXEC IN_DB_UTIL.IN_CALLSTACK_PRINT('IN_DB_UTIL');
The IN_DB_UTIL_LOG table contains a log of any exceptions that occur during the execution of the IN_DB_UTIL and IN_DB_UPGRADE packages. It also contains a log of calls to the IN_SESSION_SET, and IN_SESSION_CLEAR, and IN_SESSION_CLEAR_ALL stored procedures. SELECT * FROM INUSER.IN_DB_UTIL_LOG ORDER BY LOG_TIME