CREATE PROCEDURE [dbo].[VPROCEDURE]  
   @input_procedure_name nvarchar(max),
   /*
   *   SSMA warning messages:
   *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
   */

   @input_full_report float(53) = 0
AS
   
   /*
   *   Generated by SQL Server Migration Assistant for Oracle.
   *   Contact ora2sql@microsoft.com or visit http://www.microsoft.com/sql/migration for more information.
   */
   BEGIN

      DECLARE
         /*
         *   SSMA warning messages:
         *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
         */

         @procedure_count float(53)

      SELECT @procedure_count = count(0)
      FROM sysobjects where xtype='P' AND NAME=@input_procedure_name

      IF @procedure_count = 1 AND @input_full_report = 1
         PRINT 'Verify procedure ' + ISNULL(@input_procedure_name, '') + ' succeeded.'
      ELSE
         BEGIN
            IF @procedure_count = 0
               PRINT 'ERROR:  Verify procedure ' + ISNULL(@input_procedure_name, '') + ' failed.  Procedure not found.'
         END

   END
GO