C#调用
oracle存储过程返回数据集问题
代码如下,简单来说partRecord是我自己定义的一个类型。我找了半天,没找到C#中应该如何调用这段程序来显示表中的结果,求高手!!!!!
create or replace package body aveler_assistance_package is
procedure country_demographics(COUNTRYNAME IN test.wf_countries.country_name%TYPE ,countryInformation out partRecord ) IS
begin
select test.wf_countries.country_name,test.wf_countries.location,test.wf_countries.capital,test.wf_countries.population,test.wf_countries.airports,
test.wf_countries.climate into countryInformation
from test.wf_countries
where test.wf_countries.country_name=COUNTRYNAME;
end country_demographics;
end aveler_assistance_package;
------解决方案--------------------按照这里面的方法就行了,http://www.cnblogs.com/tohen/archive/2009/10/17/1584959.html。