62,046
社区成员
发帖
与我相关
我的任务
分享
ExecuteNonQuery(conn, CommandType.StoredProcedure, "procedureName", parms);
OracleCommand oraCmd = new OracleCommand();
oraCmd.CommandText = "存储过程名";
oraCmd.CommandType = CommandType.StoredProcedure;
OracleConnection conn = new OracleConnection(xxxxx);
oraCmd.Connection = conn;
OracleDataAdapter da = new OracleDataAdapter(oraCmd);
DataSet ds = new DataSet();
da.Fill(ds);
存储过程又该怎么写.....
create proc proc_temp (ID VARCHAR2,)
as
v_Sql VARCHAR2(1000);
begin
....
select * from table; (前面的执行完了,最后select查询,我想用程序得到查询的结果)
end;
OracleCommand oraCmd = new OracleCommand();
oraCmd.CommandText = "存储过程名";
oraCmd.CommandType = CommandType.StoredProcedure;
OracleParameter[] paras ={
new OracleParameter("i_address",OracleType.VarChar),
new OracleParameter("o_cur",OracleType.Cursor)
};
paras[0].Value = " ";
paras[0].Direction = ParameterDirection.Input;
paras[1].Direction = ParameterDirection.Output;
foreach (OracleParameter p in paras)
{
oraCmd.Parameters.Add(p);
}
OracleDataAdapter da = new OracleDataAdapter(oraCmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataSet ds = new DataSet();
new SqlDataAdapter(sqlCommand).Fill(ds);
return ds;
获取DataSet或DataTable再处理