C调用ORACLE简单存储过程.doc

C#调用oracle存储过程最简单的实例 2009-12-28? 来自：百度博客? 字体大小：【大?中?小】 Oracle方面１．创建Oracle过程存储create or replace procedure proce_test(paramin in varchar2,paramout out varchar2,paraminout in out varchar2)asvarparam varchar2(28);beginvarparam:=paramin;paramout:=varparam|| paraminout;?end;２．测试过程存储declareparam_out varchar2(28);param_inout varchar2(28);beginparam_inout:=ff;???proce_test(dd,param_out,param_inout);???dbms_output.put_line(param_out);end; C#方面引用Oracle组件?? using?System; using?System.Data; using?System.Data.OracleClient;?? ? namespace?WebApplication4 { ?????public?class?OraOprater ?????{ ?????????private?OracleConnection conn=null; ?????????private?OracleCommand cmd=null; ?????????public?OraOprater() ?????????{ ?????????????//连接数据库 ??????????????string?mConn=data source=;user id=ora;password=ora; ??????????????conn=new?OracleConnection(mConn); 牋牋牋牋牋牋牋try????con 牋牋牋牋牋牋牋{ry????c 牋牋牋牋牋牋牋牋牋燾onn.Open();w?OracleCo 牋牋牋牋牋牋牋牋牋燾md=new燨racleCommand();nection(mCo 牋牋牋牋牋牋牋牋牋燾md.Connection=conn;();nection 牋牋牋牋牋牋牋}牋燾md.Co 牋牋牋牋牋牋牋catch(Exception e)onn;(); 牋牋牋牋牋牋牋{atch(Ex 牋牋牋牋牋牋牋牋牋爐hrow爀;eption e)on 牋牋牋牋牋牋牋}牋爐hrow爀 牋牋牋牋爙牋牋}牋爐 ? 牋牋牋牋爌ublic爏tring燬pExeFor(string爉_A,string爉_B));; 牋牋牋牋爗ublic 牋牋牋牋牋牋牋牋//爏tring燬p存储过程的参数声明 ??????????????OracleParameter[] parameters={ ????????????????new?OracleParameter(paramin,OracleType.VarChar,20), ????????????????new?OracleParameter(paramout,OracleType.VarChar,20), ????????????????new?OracleParameter(paraminout,OracleType.VarChar,20) ????????????????????????????????????????????????}; ??????????????parameters[0].Value=m_A; ??????????????parameters[2].Value=m_B; ??????????????parameters[0].Direction=ParameterDirection.Input; ??????????????parameters[1].Direction=ParameterDirection.Output; ??????????????parameters[2].Direction=ParameterDirection.InputOutput; ??????????????try ??????????????{ ???????????????????RunProcedure(proce_test,parameters); ??????????????????return?parameters[1].Value.ToString(); ??????????????} ??????????????catch(Exception e)