Dataset to an oracle stored procedure

J

Jawahar Rajan

Is it possible for a Dataset that is added to a C# project to be based on a
stored Procedure?
Can I use either a OracleClient or Microsoft Oracle Client?

Any help is appreciated.


Jawahar
 
M

Miha Markic

Yes, it is possible with both.
There is no design time support for retrieving dataset metadata with MS'
Oracle provider.
I don't know about Oracle's one.
 
N

Nicholas Paldino [.NET/C# MVP]

Miha and Jawahar,

While there isn't design time support for retrieving the results of a
stored procedure using the managed provider for oracle, if you have the OLE
DB provider installed, you can get the results through that in design time
and get the data set through that.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dataset connected to an Oracle stored Proc 1
oracle transaction for stored procedure? 1
run oracle stored procedure from c# 5
Typed dataset with oracle db ? 3
DataSet Max Length Compared to Oracle Varchar2 1
Passing IN ref cursor to Oracle 9.2 using EnterpriseLibrary 1
return value from Oracle stored proc 2
Using Excel to call Oracle Stored procedure. 1

Top