string sql = "seect userName,Location,number where USER_ID=:id"; OracleCommand cmd = new OracleCommand(sql, conn); cmd.BindByName = true; OracleParameter oparam = cmd.Parameters.Add("refcursor",OracleType.RefCursor); oparam.Direction = ParameterDirection.OutPut; cmd.Parameters.Add("id", userId); cmd.Connection.Open(); cmd.ExecuteNonQuery(); OracleDataAdapter adapter = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); return ds;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)