Re: Oracle Stored Procedure

Please post this to the appropriate new list (Webforms) in future...thanks.

That's three different things.
1. Call a stored procedure from a web app.
2. Insert a row through a stored procedure.
3. Retrieve a refcursor from a stored procedure.

Which data provider are you using with Oracle? And, if its the OleDb data provider, which OLE DB provider?

I have an example of using refcursors with the OleDb data provider (using MSADAORA or OraOLEDB.Oracle OLE DB providers) posted on my website http://staff.develop.com/bobb.

I have a series of Oracle examples that need to be cleaned up for various other data providers for Oracle, which one are you using?

The "fill a datagrid" part works the same way for Oracle resultsets as SQL Server resultsets. You can set the DataSource to the DataReader desired. Or set DataSource to the DataSet, DataTable or DataView. If you set the DataSource to a DataSet, you can choose the correct table by using the DataMember property.

Hope this helps,
Bob Beauchemin
[email protected]


-----Original Message-----
From: dmlegare [mailto:[email protected]]
Sent: Wednesday, June 19, 2002 2:12 PM
To: [email protected]
Subject: [DOTNET] Oracle Stored Procedure


Can anyone share a good link or sample code that shows how to call an Oracle
Stored Procedure from an ASP.NET/C# web app? I actually and trying to do two
things... Pass data to the stored proc to insert into a table and then
retrieve data back the another proc to fill a datagrid.

I only noticed one on MSDN and there is one part I didnt understand...

tia.

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.