怎么在程序中调用在oracle中写的函数?
各位请帮帮我
包
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;