求助!这语句那里错了 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;
