The IN_CALLSTACK_GET_HIST stored procedure is used to get the last two programs from the call stack for populating the CALLER and CALLER_HIST parameters after a calling procedure either initiates the session using the IN_SESSION_SET procedure or clears its session using the IN_SESSION_CLEAR procedure.
This call stack information is only accessible within the current session, it is not visible from any other session.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | ALL (SYNC and UPGRADE) | |
| Description | Specifies the identifier for which to get the call stack history. | |
| Options |
IN_DB_UTIL SYNC UPGRADE |
|
| TAG | Type: | OUTPUT |
| Datatype: | VARCHAR2(10) | |
| Default Value: | DBMS_RANDOM.STRING('X',10) | |
| Description | The unique tag associated with the session currently using the specified identifier of the IN_CONTEXT namespace. | |
| CALLER | Type: | OUTPUT |
| Datatype | VARCHAR2(128) | |
| Default Value: | None | |
| Description | The procedure name that is currently executing for the specified identifier. The most recent entry in the call stack. | |
| CALLER_HIST | Type: | OUTPUT |
| Datatype | VARCHAR2(128) | |
| Default Value: | None | |
| Description | The procedure name that called the procedure that is currently executing for the specified identifier. The next most recent entry in the call stack. | |
Exceptions
Example
IN_CALLSTACK_GET_HIST(V_IDENTIFIER, V_TAG, V_CALLER, V_CALLER_HIST);