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