drop procedure if EXISTS validate_customer;
DELIMITER $$
CREATE  PROCEDURE `validate_customer`(IN `numIdentif` VARCHAR(20))
    NO SQL
BEGIN

        SELECT id, name, cf1, cf2, direccion, document_type_id FROM tec_customers WHERE (cf2 = numIdentif or cf1 = numIdentif) and estado = 1 limit 1;

END$$
DELIMITER ;