请问高手,怎样调用存储过程返回数据集?急啊!!!
tob 2003-07-30 02:05:59 在oracle建立了一个包,包里有一个test1的存储过程,怎么用asp.net(c#)调用存储过程返回数据集,并写到datagrid里?
create or replace package Test1 is
type rs is ref cursor;
PROCEDURE getYhRs(ydm in varchar, yhrs out rs);
end Test1;
create or replace package body Test1 is
PROCEDURE getYhRs(ydm in varchar, yhrs out rs) as
begin
open yhrs for select * from t_yonghu WHERE yhdm=ydm;
end;
end Test1;