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

         @function_count float(53)

      SELECT @function_count = count(0)
      FROM INFORMATION_SCHEMA.ROUTINES
      WHERE ROUTINE_TYPE='FUNCTION' AND ROUTINE_NAME=@input_function_name

      IF @function_count = 1 AND @input_full_report = 1
         PRINT 'Verify function ' + ISNULL(@input_function_name, '') + ' succeeded.'
      ELSE
         BEGIN
            IF @function_count = 0
               PRINT 'ERROR:  Verify function ' + ISNULL(@input_function_name, '') + ' failed.  Function not found.'
         END

   END
GO