2018-08-24 17:06
@欲风217 请问我的proc.getObject(1)报Parameter number 1 is not an OUT parameter是什么原因，
DROP PROCEDURE IF EXISTS delate_area;
CREATE PROCEDURE delate_area(in personId INT)
BEGIN
DECLARE t_error INT DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;
START TRANSACTION;
DELETE FROM area WHERE area.id=personId;
IF t_error = 1 THEN
ROLLBACK;
ELSE
COMMIT;
END IF;
SELECT t_error;
END
我的存储过程是这样写的
2018-08-10 16:00
好的谢谢波总
