The IN_DB_UTIL_SP_CALLSTACK_EXTEND stored procedure is responsible for incrementing the call stack depth for the specified identifier(s) when the IN_DB_UTIL_SP_SESSION_SETUP procedure is executed during session initialization.
The IN_DB_UTIL_SP_CALLSTACK_EXTEND procedure should never need to be manually executed. The call stack for each identifier is stored in the IN_DB_UTIL_CALLSTACK table.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the identifier for which to extend the call stack. | |
| Options |
IN_DB_UTIL SYNC UPGRADE ALL (SYNC and UPGRADE) |
|
| CALLER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the name of the procedure that called the IN_DB_UTIL_SP_SESSION_SETUP procedure to initialize the session within the framework, which includes extending the call stack for the specified identifier(s). | |
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options | YES NO |
|
| V_RETURN_VAL | Type: | RETURN |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the procedure was successful or
not. 0 = SUCCESS 1 = ERROR |
|
Examples
EXEC IN_DB_UTIL_SP_CALLSTACK_EXTEND @IDENTIFIER, @V_CALLER;