关于Oracle 游标返回值 在C#中的运用（引用自www.souzz.net，个人学习参考用）

 1. 调用包含out/ in out类型参数的存储过程

存储过程:

CREATE OR REPLACE PROCEDURE "SITE_EDITSITEDATAEXIST"

(id_ number,

name_ varchar2,

httpRoot_ varchar2,

flag out integer )//out 只具备输出功能 in out 为输入/输出型

as

tempNum integer;

begin

flag:=0;

select count(id) into tempNum from WebSite_Info where Name = name_ and ID<>id_;

 

if tempNum > 0 then

flag:=3;

end if;

select count(id) into tempNum from WebSite_Info where HttpRoot = HttpRoot_ and ID<>id_;

 

if tempNum > 0 then

flag:=4;

end if;

 

commit;

end ;

/

调用方法:

 

OracleParameter retPar = new OracleParameter(“channelId”, OracleType.Number);

retPar.Direction = ParameterDirection.Output;//此处和存储过程中的类型匹配

//如果为in out 类型 此处应声//明InputOutput

OracleParamet