[SQL ] 關於Function
請問各位
我用的資瞭庫是DB2 寫了一個function如下:
CREATE FUNCTION "TOOLS"."TEST"()
RETURNS VARCHAR(512)
SPECIFIC test
LANGUAGE SQL READS SQL DATA
BEGIN
DECLARE out_str VARCHAR(512) DEFAULT '';
DECLARE num_x NUMERIC(9,6) DEFAULT 0;
DECLARE ori_x CURSOR FOR SELECT X FROM TW1.TMP_DB2SHP_PLACE_GEOMETRY WHERE
SEQ1= 1;
DECLARE l INTEGER DEFAULT 1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET l = 0;
OPEN ori_x;
X_LOOP: LOOP
FETCH ori_x INTO num_x;
SET out_str = INSERT(out_str,LENGTH(out_str),0,num_x);
IF l = 0 THEN LEAVE X_LOOP; END IF;
SET out_str = INSERT(out_str,LENGTH(out_str),0,',');
END LOOP;
CLOSE ori_x;
RETURN out_str;
END
結果執行後產生如下錯誤訊息:
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=<variable
declaration>;;<SQL statement>, DRIVER=3.50.152
請問是哪裡出問題呢??
感謝各位~~
--
It's Impossible To Give A Hug Without Getting One Back.
By Garfield
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.130.36.2