关于两层游标的用法的疑问
一直用sqlserver，没有用过oracle，现在写了个存储过程，用两层游标，语法有问题？还是oracle不能这么写？
代码；
create or replace procedure updatetime is
v_jtdid NUMBER;
v_audittaskid VARCHAR2(10);
cursor cursor1 is select * from (select jd.jtdid from tz_jobtypedetail jd where jd.jtid = 1001 order by jd.orderno ) where rownum < 5 ;
begin
open cursor1;
fetch cursor1 into v_jtdid;
while cursor1%found loop
begin
CURSOR cursor2 is select * from ( select a.audittaskid,a.creattime,a.orderdate,a.releasedate from tz_audittaskrelease a where a.categoryid = v_jtdid order by trunc(dbms_random.value(0, 1000))) where rownum < 13;
begin
open cursor2;
fetch cursor2 into v_audittaskid;
while cursor2%found loop
begin
update tz_audittaskrelease set creattime = sysdate ,orderdate = sysdate ,releasedate = sysdate where audittaskid = v_audittaskid;
end
fetch cursor2 into v_audittaskid;
end loop;
close cursor2;
end;
fetch cursor1 into v_jtdid;
end;
end loop;
close cursor1;
end;
[解决办法]
把CURSOR cursor2 is select * from 的定义拿到Cursor1和begin之间定义。
