DROP PROCEDURE IF EXISTS sp_alm_guiaremision_modificar;
DELIMITER $$
CREATE  PROCEDURE `sp_alm_guiaremision_modificar`(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_referral_guide`
SET 
flg_response = flg_responseP,
error_code = error_codeP, 
response_descrip = response_descripP,
digest_value = digest_valueP
where id = idP;

END$$
DELIMITER ;