日期:2014-05-17  浏览次数:20801 次

求助!这语句那里错了 ORACLE 语法不熟啊 T_T
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;