问题描述

oracle 总是出现ora-00937和ora-06512 at line 12

DECLARE

a number := 0000000129;
b number := 0000000137;
count number := 0;
BEGIN

WHILE a<=b LOOP
DECLARE

c number := 0000000121;

d number := 0000000138;

BEGIN

WHILE c<d LOOP

insert into od
select 站点起,站点终,count(cid) from wu1 where 起站编号=a and 终站编号=c;
c := c+1;

END LOOP;
END;
a := a+1;
END LOOP;
END;

解决方案

DECLARE??
a number := 0000000129;
b number := 0000000137;
count number := 0;
BEGIN?
?WHILE a<=b LOOP
DECLARE??
c number := 0000000121;?
d number :=......
答案就在这里：oracle 循环嵌套 插入表中 总是出现ora-00937和ora-06512 at line 12

解决方案二：

http://bbs.csdn.net/topics/390953754