net 调用存储过程的out参数(在oracle中测试准确,但net显示不对)
net 调用存储过程的out参数(在oracle中测试正确,但net显示不对)
我在oracle测试存储过程都是有数据出,总记录数为56,页数为3.8页


为什么我在net中这样调用,得到的结果这两个数都为2呢?
private static string getpages(int pages,string fields,int pagesize,string tablename,string strwhere,string orderby, out int Vnumber,out int pagecounts, out DataTable dtresult)
{
string restr="";
int num=0;
int pagec=0;
DataTable kk = new DataTable();
OracleParameter[] pan = {
new OracleParameter("pages", OracleDbType.Int32),//--数据页数,从1开始
new OracleParameter("fields", OracleDbType.Varchar2),
new OracleParameter("pageSize", OracleDbType.Int32),//--每页大小
new OracleParameter("tableName", OracleDbType.Varchar2),
new OracleParameter("strWhere", OracleDbType.Varchar2),
new OracleParameter("Orderby", OracleDbType.Varchar2),
new OracleParameter("numCount", OracleDbType.Int32),//--总记录数
new OracleParameter("pagecounts", OracleDbType.Int32),//--总记录数
// pagecounts
new OracleParameter("v_cur", OracleDbType.RefCursor)
};
pan[0].Value = pages;
pan[1].Value = fields;
pan[2].Value = pagesize;
pan[3].Value = tablename;
pan[4].Value = strwhere;
pan[5].Value = orderby;
pan[6].Value = ParameterDirection.Output;
pan[7].Value = ParameterDirection.Output;
pan[8].Direction = ParameterDirection.Output;
try
{
kk=qg_oracleconnet.ExecuteDataTableByProc("qg_pages",pan);
我在oracle测试存储过程都是有数据出,总记录数为56,页数为3.8页
为什么我在net中这样调用,得到的结果这两个数都为2呢?
private static string getpages(int pages,string fields,int pagesize,string tablename,string strwhere,string orderby, out int Vnumber,out int pagecounts, out DataTable dtresult)
{
string restr="";
int num=0;
int pagec=0;
DataTable kk = new DataTable();
OracleParameter[] pan = {
new OracleParameter("pages", OracleDbType.Int32),//--数据页数,从1开始
new OracleParameter("fields", OracleDbType.Varchar2),
new OracleParameter("pageSize", OracleDbType.Int32),//--每页大小
new OracleParameter("tableName", OracleDbType.Varchar2),
new OracleParameter("strWhere", OracleDbType.Varchar2),
new OracleParameter("Orderby", OracleDbType.Varchar2),
new OracleParameter("numCount", OracleDbType.Int32),//--总记录数
new OracleParameter("pagecounts", OracleDbType.Int32),//--总记录数
// pagecounts
new OracleParameter("v_cur", OracleDbType.RefCursor)
};
pan[0].Value = pages;
pan[1].Value = fields;
pan[2].Value = pagesize;
pan[3].Value = tablename;
pan[4].Value = strwhere;
pan[5].Value = orderby;
pan[6].Value = ParameterDirection.Output;
pan[7].Value = ParameterDirection.Output;
pan[8].Direction = ParameterDirection.Output;
try
{
kk=qg_oracleconnet.ExecuteDataTableByProc("qg_pages",pan);