Hi:
I am a newbie to accessing oracle stored procedures in C#.

I have an oracle procedure that returns more than one
row.
I wanted to get the rows and store in a dataset in C#
using OleDbDataAdapter.
I know how to do that for SQL server stored procedure
using SQLDataAdapter. I believe it's quite different for
Oracle.

It would be great if some one can post an example of an
oracle stored procedure and the way to fill it in to a
dataset using OleDbDataAdapter.
Thanks in Advance.

Hi Nathan


use either Oracle's .net data provider or Microsoft's Oracle dot net data
provider. i have used MS's Oracle dot net data provider......

OracleCommand cmd = null;

OracleDataAdapter adap = null;

cmd = new OracleCommand(storedProcedureName);

cmd.Connection = oracleConnection;

cmd.CommandType = CommandType.StoredProcedure;

// add parameters here

//cmd.Parameters.Add(oracleParameter);

//


adap = new OracleDataAdapter(cmd);

DataTable dt = new System.Data.DataTable("SqlSP");

if(oracleConnection.State!=ConnectionState.Open)

{

oracleConnection.Open();

}

adap.Fill(dt);

-Sethu

[quoted text, click to view]