在线急等 !!!!!!!!!
存储过程是以下这个样子的
create or replace
PACKAGE TOS_SP_DOCTORMST AS
TYPE CursorType IS REF CURSOR;
PROCEDURE GET_DOCTORMST(v_doctorcodeVers IN VARCHAR2,
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT CursorType,
v_totalCount OUT VARCHAR2);
END;
我写个程序调用这个存储过程
string conStr = "...................";
DataSet ds = new DataSet();
Oracle.DataAccess.Client.OracleConnection con = new Oracle.DataAccess.Client.OracleConnection(conStr);
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter("GET_DOCTORMST", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.Fill(ds);
Console.Read();
请问存储过程的参数在代码里面怎么写啊? 尤其是红色的游标
------解决方案--------------------
参考 关于存储过程参数输入输出http://www.cnblogs.com/VitoriaTang/archive/2006/08/04/467765.html
------解决方案--------------------
http://blog.csdn.net/itblog/article/details/752869