Following code snippet uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database.
Using the DataReader can increase application performance and reduce system overhead because only one row is ever in memory.
using(OracleConnection conn = new OracleConnection (@"DataSource=source;User Id=username;Password=password;")) { OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "StoredProcedureName"; cmd.Parameters.Add("Result",OracleType.Cursor).Direction = ParameterDirection.Output; conn.Open(); OracleDataReader dataReader = cmd.ExecuteReader(); while(dataReader .Read()) { // do your logic here } conn.Close(); }
|
|
No comments:
Post a Comment