之前对Oracle的接触都未牵涉到这一块的,刚开始确实不知道怎么处理,网上也查了写资料,但是都比较散,所以还是整理一下吧,仅供大家参考:
1、oracle中存储过程如下:
CREATE OR REPLACE PROCEDURE UP_dzSURFACE_EBGJSY(
TKALA VARCHAR2 , RC1 out PK_Var.RC )
AS
sSQL varchar2(2000) ;
begin
sSQL := ' select
TKALA as "旧编号" ,
GCEABG as "取样深度" , "LOAD1" as "加荷" ,
GCDLAG as "a" , GCDKBD as "Es" , GCDLAQ as "回弹指数Cs"
from tbdzEBGJSY where Upper(TKALA)='''|| Upper(TKALA) || ''' ' ;
Open RC1 for sSQL;
return;
end UP_dzSURFACE_EBGJSY;
2、c#代码如下:
//创建oracle参数
OracleParameter[] sqlParme = new OracleParameter[2]
//参数1
sqlParme[0] = new OracleParameter("RC1", OracleType.Cursor);