The IN_CONTEXT_PRINT stored procedure is used to interface with the IN_CONTEXT_GET function to get and print the attribute values for the specified identifier of the IN_CONTEXT context namespace.
The output of IN_CONTEXT_PRINT includes the last two calls in the call stack for the specified identifier. The OPERATION attribute, which is also referred to as CALLER in some cases, is the current operation in the call stack. The CALLED_BY attribute is the previous operation (COUNT-1), which is also referred to as CALLER_HIST in some cases.
| Parameter | Description | |
|---|---|---|
| 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 ALL (SYNC and UPGRADE) |
|
Examples
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT(IDENTIFIER);
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT;
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT('ALL');
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT('SYNC');
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT('UPGRADE');
EXEC IN_DB_UTIL.IN_CONTEXT_PRINT('IN_DB_UTIL');
Example output
Example from the IN_DB_UTIL.CLEANUP_AUDIT_DATA stored procedure.
Current DB Time: 2022-07-29 13:36:39.776000 Current UTC Time: 2022-07-29 18:36:39.776000 Current Activity for the IN_DB_UTIL identifier: IN_DB_UTIL TAG: 7B37GKNLZ7 IN_DB_UTIL STATUS: EXECUTING IN_DB_UTIL OPERATION: CLEANUP_AUDIT_DATA IN_DB_UTIL CALLED BY: NULL IN_DB_UTIL START TIME: 2022-07-29 13:36:39.774000 IN_DB_UTIL MAX TIME: 2022-07-29 14:36:39.774000 IN_DB_UTIL MAX MINUTES: 60 IN_DB_UTIL OBJECT: IN_AUDIT IN_DB_UTIL SUBOBJECT: NULL IN_DB_UTIL TABLESPACE: NULL IN_DB_UTIL BATCH SIZE: 10000 IN_DB_UTIL BULK LIMIT: NULL IN_DB_UTIL PARALLEL: 1 IN_DB_UTIL LOGGING: NULL IN_DB_UTIL OS USER: LOCAL_DOMAIN\USER_NAME IN_DB_UTIL DB_SESSION: 742,52540
Example from the IN_DB_UPGRADE.UPTIME_STEPS stored procedure.
Current DB Time: 2022-08-01 09:22:37.849000 Current UTC Time: 2022-08-01 14:22:37.849000 Current Activity for the SYNC identifier: SYNC TAG: NULL SYNC STATUS: IDLE SYNC OPERATION: NULL SYNC CALLED BY: NULL SYNC START TIME: NULL SYNC MAX TIME: NULL SYNC MAX MINUTES: NULL SYNC OBJECT: NULL SYNC SUBOBJECT: NULL SYNC TABLESPACE: NULL SYNC BATCH SIZE: NULL SYNC BULK LIMIT: NULL SYNC PARALLEL: NULL SYNC LOGGING: NULL SYNC OS USER: NULL SYNC DB_SESSION: NULL Current Activity for the UPGRADE identifier: UPGRADE TAG: WNCBNP25DV UPGRADE STATUS: EXECUTING UPGRADE OPERATION: CREATE_INDEXES_IN_DOC UPGRADE CALLED BY: UPTIME_STEPS_IN_DOC UPGRADE START TIME: 2022-08-01 09:22:37.849000 UPGRADE MAX TIME: 2022-08-01 10:22:35.891000 UPGRADE MAX MINUTES: 60 UPGRADE OBJECT: NEW_DOC UPGRADE SUBOBJECT: NEW_DOC_IDX2 UPGRADE TABLESPACE: INDX UPGRADE PARALLEL: 10 UPGRADE LOGGING: LOGGING UPGRADE SCHEMA TARGET: 7.7.0.0 UPGRADE SCHEMA VERSION: 7.1.3.3 UPGRADE IS SYNC UPGRADE: YES UPGRADE OS USER: LOCAL_DOMAIN\USER_NAME UPGRADE DB_SESSION: 742,52540 PL/SQL procedure successfully completed.