CREATE PROCEDURE [dbo].[VVIEW]  
   @input_view_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.
         */

         @view_count float(53)

      SELECT @view_count = count(0) FROM sysobjects
      WHERE xtype='V'AND
            NAME = @input_view_name

      IF @view_count = 1 AND @input_full_report = 1
         PRINT 'Verify view ' + ISNULL(@input_view_name, '') + ' succeeded.'
      ELSE
         BEGIN
            IF @view_count = 0
               PRINT 'ERROR:  Verify view ' + ISNULL(@input_view_name, '') + ' failed.  View not found.'
         END

   END
GO