Procedure will check if stored procedure with the given name (and signature) exists in the database and will attempt to drop it.
Arguments
-
v_Object_Name – Procedure Name, Variable Character (128) in Netezza, SYSNAME in SQL Server.
-
v_Signature – Signature, Variable Character (128) (Required parameter in Netezza and Optional Reserved parameter in SQL Server)
Note:
Supported in Netezza and SQL Server versions at this time. As workaround In the Oracle version of the framework please use ‘WHENEVER SQLERROR CONTINUE’ command where needed;
Examples
SQL Server
EXECUTE DBTD_DROP_PROC_IF_EXISTS 'SP_REPORT_ERROR' ,'';
EXECUTE DBTD_DROP_PROC_IF_EXISTS 'MyServer.MyDatabase.MySchema.SP_REPORT_ERROR';
Netezza
CALL DBTD_DROP_PROC_IF_EXISTS( 'SP_DO_SOMETHING','(VARCHAR(128),VARCHAR(128))');
See Also