db2一个存储过程的问题
为什么创建以下的存储过程老是报错?请假下哪里写的有问题?如果把分割线上线任一一部分的游标去掉是正确的,放在一起就报错
CREATE PROCEDURE db2admin.proc_PointInfoForGIS (IN proleid DECIMAL,IN pbuildingid DECIMAL)
RESULT SETS 2
LANGUAGE SQL
BEGIN
DECLARE v_mid INTEGER DEFAULT 0;
DECLARE EContent VARCHAR(800);
DECLARE c1 CURSOR FOR
select M_ID from PlaceInfo
where BuildingID=pbuildingid;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET EContent = '';
FETCH c1 INTO v_mid;
SET EContent = EContent ;
CLOSE c1;
--------------------------------------------------------------------
DECLARE Cr CURSOR WITH RETURN FOR
select * from Table;
OPEN Cr ;
END@