drop procedure if exists update_Xml_sale;
DELIMITER $$
CREATE  PROCEDURE `update_Xml_sale`(IN `idP` INT, IN `flg_responseP` INT, IN `error_codeP` VARCHAR(15), IN `response_descripP` VARCHAR(2000), IN `digest_valueP` VARCHAR(250))
    NO SQL
BEGIN

update `tec_sales`
SET 
flg_response = flg_responseP,
error_code = error_codeP, 
response_descrip = response_descripP,
digest_value = digest_valueP
where id = idP;

END$$
DELIMITER ;