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

The IN_CALLSTACK_PRINT stored procedure is used to fetch and print the entire call stack for the specified identifier.

The call stack for each identifier is stored in memory using a global variable defined with the IN_CALLSTACK_TABLE table type.

The entire call stack for a session is only visible to the current session, it is not visible to any other session. However, the two most recent call stack entries are recorded within the IN_CONTEXT namespace for the identifier and is visible to all sessions by referencing the OPERATION and CALLED BY attributes using the IN_CONTEXT_PRINT procedure or the SYS_CONTEXT function.

Parameter	Description
IDENTIFIER	Type:	INPUT
	Datatype:	VARCHAR2(128)
	Default Value:	ALL (SYNC and UPGRADE)
	Description	Specifies the identifier for which to print the call stack.
	Options	IN_DB_UTIL SYNC UPGRADE ALL

Exception

OTHERS

Examples

EXEC IN_DB_UTIL.IN_CALLSTACK_PRINT; 
EXEC IN_DB_UTIL.IN_CALLSTACK_PRINT(V_IDENTIFIER);

Example Output

Example output during the execution the CLEANUP_AUDIT_DATA procedure.

***** Call Stack Begin ***** ***** 


IN_DB_UTIL Call Stack ***** 

Depth  Tag          Procedure 
------ ------------ ----------------------------------- 
1      0527044CB3   CLEANUP_AUDIT_DATA 

***** Call Stack End *****

Note: Depending on the IN_DB_UPGRADE procedure currently using the IN_DB_UTIL framework, it could be consuming either the SYNC or UPGRADE identifier or both (ALL). The call stack for each identifier is extended or trimmed separately so it’s normal to see varying depths for each identifier based on the sequence of procedures being executed.

Example output at a specific point during the execution of the IN_DB_UPGRADE.UPTIME_STEPS procedure.

***** Call Stack Begin ***** 
***** SYNC Call Stack ***** 
Depth   Tag          Procedure 
------ ------------ ----------------------------------- 
1      M54LEDMYP8   CREATE_PK_IN_DOC 

***** UPGRADE Call Stack ***** 

Depth   Tag         Procedure 
------ ------------ ----------------------------------- 
1       M54LEDMYP8  UPTIME_STEPS 
2       M54LEDMYP8  SCHEMA_UPGRADE_7403_7500 
3       M54LEDMYP8  UPTIME_STEPS_IN_DOC 
4       M54LEDMYP8  CREATE_PK_IN_DOC

 
***** Call Stack End *****

Example output at a specific point during the execution of the IN_DB_UPGRADE.DOWNTIME_STEPS procedure.

***** Call Stack Begin ***** 

***** SYNC Call Stack ***** 

Depth  Tag          Procedure 
------ ------------ ----------------------------------- 
1 2VIDAEWULF DOWNTIME_STEPS 
2 2VIDAEWULF DOWNTIME_STEPS_IN_DOC 
3 2VIDAEWULF CREATE_FK_IN_DOC
 
***** UPGRADE Call Stack ***** 
Depth  Tag          Procedure 
------ ------------ ----------------------------------- 
1      2VIDAEWULF   DOWNTIME_STEPS 
2      2VIDAEWULF   SCHEMA_UPGRADE_7403_7500 
3      2VIDAEWULF   DOWNTIME_STEPS_IN_DOC 
4      2VIDAEWULF   CREATE_FK_IN_DOC 

***** Call Stack End *****