DO BEGIN DECLARE error NVARCHAR(100); DECLARE docTotal DECIMAL(18,2); DECLARE Retorno INTEGER; docTotal := 0; Retorno := 1; SELECT MAX(T0."DocTotal") INTO docTotal FROM "IV_C1_Contract" T0 WHERE T0."Id" = @documentId; IF (docTotal > 100.000000) THEN BEGIN error := 'Valor do contrato excede o total permitido'; Retorno := 0; END; END IF; SELECT Retorno, error FROM DUMMY; END;