hi guys please help me m trying to call a stored procedure from a oracle database below is my code
string
sSql = string.Empty;sSql =
"SP_ReturnHosts"; OracleCommand sel = new OracleCommand(sSql, g_conn);sel.CommandType =
CommandType.StoredProcedure;sel.Parameters.Add(
"cursor_res", OracleType.Cursor).Direction=ParameterDirection.Output; OracleDataAdapter da = new OracleDataAdapter(); DataSet ds = new DataSet();g_conn.Open();
a.SelectCommand = sel;
da.Fill(ds);
o_dt = ds.Tables[0];
g_conn.Close();
all I need to know is if there is a way of doing this in a better way without using both oracle command and DataAdapter(like in ms sql sever where you just use dataadapter only),
Thanks
Vijaya KadiyalaPosted Apr 5, 2009, 7:31 AM
Hi
When you say better than this and in MS SQL Server... What are you looking for? What is your requirement??
Thanks -- Vijaya Kadiyala
www.DotNetVJ.com
Mirko MeierPosted Mar 25, 2009, 5:58 AM