Re: Trigger calling stored procedure

[William Chiquito]

Hi Jim,

Try:

DELIMITER $$

DROP TRIGGER `updt_tbl1`$$

CREATE TRIGGER `updt_tbl1` BEFORE UPDATE ON `main_table`
FOR EACH ROW
   CALL a_stored_procedure(NEW.col1, NEW.col2, OLD.tblkey);
$$

DELIMITER ;

DELIMITER $$

DROP PROCEDURE IF EXISTS `a_stored_procedure`$$

CREATE PROCEDURE `a_stored_procedure`(val1 INT, val2 INT, val3 INT)
BEGIN
UPDATE table2 SET col1 = val1, col2 = val2 WHERE tblkey = val3;
UPDATE table3 SET col1 = val1, col2 = val2 WHERE tblkey = val3;
END$$

DELIMITER ;