--参考create or replace package pkg_test as type myCursor is ref cursor; function get(p_id number) return myCursor; end pkg_test;create or replace package body pkg_test as function get(p_id number) return myCursor is rc myCursor; strsql varchar2(200); begin if p_id=0 then open rc for select a.user_name from fnd_user a ; else strsql:='select a.user_name from fnd_user a where a.user_id=:p_id'; open rc for strsql using p_id; end if; return rc; end get;
end pkg_test; 不知道你是一次返回多个记录集呢,还是根据条件返回一个记录集,以上的如果需要你参考一下吧
csdn有写包返回记录集的例子个人觉得,不要这样返回。(其实是能力不行)
as
type myCursor is ref cursor;
function get(p_id number) return myCursor;
end pkg_test;create or replace package body pkg_test
as
function get(p_id number) return myCursor is
rc myCursor;
strsql varchar2(200);
begin
if p_id=0 then
open rc for select a.user_name from fnd_user a ;
else
strsql:='select a.user_name from fnd_user a where a.user_id=:p_id';
open rc for strsql using p_id;
end if;
return rc;
end get;
end pkg_test;
不知道你是一次返回多个记录集呢,还是根据条件返回一个记录集,以上的如果需要你参考一下吧
还有如果可以返回多个记录集,然后怎么在ASP页面里取记录集呢?用rs.nextrecordset?