CREATE OR REPLACE PROCEDURE MC
(bds in varchar2)
as CURSOR c1 IS select * From b$common_n where cd_bds=bds and g3e_fno<>449;
begin
FOR c IN c1 LOOP
if c.g3e_fno=390 then
end if;
end loop;
commit;
end;
end MC;
(bds in varchar2)
as CURSOR c1 IS select * From b$common_n where cd_bds=bds and g3e_fno<>449;
begin
FOR c IN c1 LOOP
if c.g3e_fno=390 then
end if;
end loop;
commit;
end;
end MC;
(bds in varchar2)
asCURSOR c1 IS select * From b$common_n where cd_bds=bds and g3e_fno<>449;
begin
FOR c IN c1 LOOP
if c.g3e_fno=390 then
dbms_output.put_line('?');--干点什么
end if;
end loop;
commit;
end MC;
(bds in varchar2)
as
begin
FOR c IN select * From b$common_n where cd_bds=bds and g3e_fno<>449;
LOOP
if c.g3e_fno=390 then
dbms_output.put_line('?');--干点什么
end if;
end loop;
commit;
end MC;
原来多了一个END
楼上的那种写法还是有错 @_@
这个sql有问题,检查一下.其他地方看不出问题来.
你改成select 390 g3e_fno from dual 测试就没问题.