Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> C# and Oracle 8i - returns from stored procedures
I'm accessing a stored procedure that returns two parameters, the first
is a string and the second is a cursor. I get the cursor data but not
the string. Any ideas?
Current code as follows :
OracleConnection conn = new OracleConnection(connString);
DataSet myDataSet = new DataSet();
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "dag_select.mpe_list"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_mtype",OracleType.LongVarChar,32).Value = ""; cmd.Parameters.Add("p_mname",OracleType.LongVarChar,32).Value = "";
for (int count = 0; count < myDataSet.Tables[0].Rows.Count; count++)
{
// process rows from cursor
}
More info:
using C#.net, Oracle 8i, Windows 2000
Received on Thu Jan 27 2005 - 11:57:43 CST