刚开始学写存储过程，问题请教

.......

create procedure normal(IN num char(3))
LANGUAGE SQL

BEGIN
DECLARE NUM2 CHAR(3);
DECLARE NAME VARCHAR(29);
DECLARE SQLSTATE CHAR(5);
DECLARE at_end SMALLINT DEFAULT 0;

DECLARE NOT_FOUND CONDITION FOR SQLSTATE '02000';
DECLARE C1 CURSOR with return FOR
SELECT DEPTNO,DEPTNAME FROM DEPARTMENT WHERE DEPTNO=num;
DECLARE EXIT HANDLER FOR NOT_FOUND
set at_end=1;


OPEN C1;
FETCH C1 INTO NUM2,NAME;
close C1;

DECLARE C2 CURSOR with return FOR
SELECT EMPNO,FIRSTNME,LASTNAME FROM EMPLOYEE where WORKDEPT=NUM2;


OPEN C2;
END @


DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "<cursor declaration>" was found following "".  
Expected tokens may include:  "<SQL statement>".  LINE NUMBER=23.  
SQLSTATE=42601


提示说DECLARE C2 CURSOR with return FOR 这里有错误，但我觉得错误不在这里，应该是其它地方有问题
请高手指教

[ 本帖最后由 ....... 于 2008-8-14 17:25 编辑 ]

.......

请各位帮帮忙啊

[ 本帖最后由 ....... 于 2008-8-14 17:25 编辑 ]

暮云

DECLARE C1 CURSOR with return FOR

DECLARE C2 CURSOR with return FOR

只能定义一个 with return 的游标吧

.......

我改掉了，可是还是不行，我把程序改成这样以后，仍然是那个地方错误

create procedure normal(IN depno char(3))
reads sql data
LANGUAGE SQL

BEGIN
DECLARE NUM2 CHAR(3);
DECLARE SQLSTATE CHAR(5);
DECLARE at_end SMALLINT DEFAULT 0;

SELECT DEPTNO into NUM2 FROM DEPARTMENT WHERE DEPTNO=depno;

DECLARE C1 CURSOR with return FOR
SELECT EMPNO,FIRSTNME,LASTNAME FROM EMPLOYEE where WORKDEPT=NUM2;


OPEN C1;

END  


仍然是游标那里有错误，我实在找不出语法上有啥问题，请各位帮忙