create or replace function fn (iOrcCode in varchar2)
return varchar2 is Result varchar2(1000);
type myCursor is ref cursor;
mCurORC myCursor;begin
if(iOrcCode is not null)then
open mCurORC for
select name,res from T_USER;
for curRecord in mCurORC loop select * from T_USER where name=curRecord.name;
end loop;
close mCurORC;
end if;
end;错误信息如下:
Error: PLS-00221: 'MCURORC' 不是过程或尚未定义
Error: PL/SQL: Statement ignored
return varchar2 is Result varchar2(1000);
type myCursor is ref cursor;
mCurORC myCursor;begin
if(iOrcCode is not null)then
open mCurORC for
select name,res from T_USER;
for curRecord in mCurORC loop select * from T_USER where name=curRecord.name;
end loop;
close mCurORC;
end if;
end;错误信息如下:
Error: PLS-00221: 'MCURORC' 不是过程或尚未定义
Error: PL/SQL: Statement ignored
create or replace function fn (iOrcCode in varchar2)
return varchar2 is Result varchar2(1000);
type myCursor is ref cursor;
mCurORC myCursor;begin
if(iOrcCode is not null)then for curRecord in(select name,res from T_USER)
loop
select * from T_USER where name=curRecord.name;
end loop;
end if;
end;