各位请帮帮我,
包
create or replace package TEXT4 is
type CUR is ref cursor;
function f_Get(f_id in varchar2) return CUR;
end TEXT4;
包体
create or replace package body TEXT4 is
function F_Get(F_id in varchar2) return CUR is
M_CUR CUR;
begin
open M_CUR FOR
select * from student where id=f_id;
return M_CUR;
end;
end TEXT4;
我要用函数的返回结果怎么用啊?
包
create or replace package TEXT4 is
type CUR is ref cursor;
function f_Get(f_id in varchar2) return CUR;
end TEXT4;
包体
create or replace package body TEXT4 is
function F_Get(F_id in varchar2) return CUR is
M_CUR CUR;
begin
open M_CUR FOR
select * from student where id=f_id;
return M_CUR;
end;
end TEXT4;
我要用函数的返回结果怎么用啊?
SQL> select *from dual;D
-
X
TEXT4.F_GET('10000');
end
这样也应该可以
你可以用诸如 FETCH TEXT4.F_GET('10000') INTO 来逐条取得里面的记录。