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;
------解决方案--------------------
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
dbms_output.put_line( '? ');--干点什么
end if;
end loop;
commit;
end MC;