DROP PROCEDURE IF EXISTS `phoneDeal`;
CREATE DEFINER = `root`@`localhost` PROCEDURE `phoneDeal`()
BEGIN
declare user_no1 varchar (100);
declare user_name2 varchar (100);
DECLARE t_error INTEGER DEFAULT 0;
DECLARE done INT DEFAULT 0;
DECLARE cur1 CURSOR FOR
select
user_no,
user_name
from
comm_system_user
where user_id < 100;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error = 1;
OPEN cur1;
START TRANSACTION;
emp_loop :
LOOP
FETCH cur1 INTO user_no1,
user_name2;
IF done = 1
THEN LEAVE emp_loop;
END IF;
select
user_no1;
-- TODO
END LOOP emp_loop;
IF t_error = 1
THEN ROLLBACK;
ELSE COMMIT;
END IF;
CLOSE cur1;
END;