Oracle Stored Procedure - with more than a row?

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

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.
 
Nathan said:
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.
Click to expand...

Switch to the Oracle provider (ODP.NET). It's free, supported, has more
features and better performance than the alternatives, and there are a ton
of examples online at oracle.com.

http://otn.oracle.com/tech/windows/odpnet/index.html

David
 
Back
Top