oracle存储过程循环嵌套0
imac777.06.12浏览293次分享举报
-- Created on -11-4-星期四 by ADMINISTRATOR
declare
-- Local variables here
EXPR_ID CHAR(10);
KMB_ID CHAR(10);
EXPR_VALUE CHAR(100);
KMB_VALUE CHAR(100);
EXPR_VALUE_TMP NUMBER(16,2);
cursor cursor1 is select zbh,zbgs from a_zbgsb;
begin
for expr1 in cursor1 loop
EXPR_ID:=expr1.zbh;
EXPR_VALUE:=expr1.zbgs;
cursor cursor2 is select kmh,kmye from a_kmyeb;
begin
for expr2 in cursor2 loop
KMB_ID:=expr2.kmh;
KMB_VALUE:=expr2.kmye;
EXPR_VALUE_TMP:= REPLACE( EXPR_VALUE, RTRIM(KMB_ID), RTRIM(KMB_VALUE) );
insert into a_zbyeb values (EXPR_ID,EXPR_VALUE_TMP) ;
end loop;
end;
end loop;
end;
各位大哥,小弟是刚刚解除oracle存储过程,想问问我这么个写法语法上有问题吗?运行的时候总是报在 cursor2这个地方有错!求各位大哥帮帮忙!