The IN_DB_UTIL_SP_DROP_UPGRADE_PROCS stored procedure will drop all the objects that are created as part of the IN_DB_UPGRADE package.
If using the debug option then the objects being deleted will be printed in the messages tab during deletion.
| Parameter | Description | |
|---|---|---|
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display additional debugging information during execution, including background operations such as session setup and state changes and call stack details. | |
| Options |
YES = Display additional details to the Messages tab NO = Do not display additional details to the Message tab |
|
| V_RETURN_VAL | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description |
Specifies whether the execution of the procedure was successful or not. 0 = Success 1 = Error |
|
Examples
EXEC IN_DROP_UPGRADE_PROCS EXEC IN_DROP_UPGRADE_PROCS 'YES'