急求个存储过程的问题。。。没辙了。。。
CREATE PROCEDURE db2admin.proc_PointInfoForGIS
(IN proleid DECIMAL,IN pbid DECIMAL,OUT pBname VARCHAR(100),OUT pAdd VARCHAR(100),OUT pIntro VARCHAR(100),OUT pContent VARCHAR(800))
RESULT SETS 2
LANGUAGE SQL
BEGIN
DECLARE v_mid VARCHAR(200);
DECLARE v_pername VARCHAR(200);
DECLARE p VARCHAR(200);
DECLARE c1 CURSOR FOR
select M_ID,PreferencesName from PlaceInfo
where BuildingID=pbid;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET pContent = '';
OPEN c1;
FETCH c1 INTO v_mid,v_pername;
set p='';
select rtrim(cast(statusValue as CHAR(20))) into p from Device_status where M_ID=v_mid fetch first 1 rows only ;
set pContent =pContent || v_pername || ':'||p||'<br/>';
FETCH c1 INTO v_mid,v_pername;
END@
--------------------------------------------
想拼一个循环,把value取出来,拼一个pContent 作为输出,但是结果老是不对,也不知道怎么调试,请教各位一下