By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,160 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,160 IT Pros & Developers. It's quick & easy.

Calling Oracle Stored Procs

P: n/a
JV
A ref cursor data type can obviously be returned as an output parameter of a
stored procedure, but can an ASP.NET application call an oracle proc that
uses a ref cursor as an input parameter? If so, how? What object do you
pass as that parameter?

We are using System.Data.OracleClient, but if necessary, we might be able to
switch.
Nov 21 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Hi Dear JV,

here are the some links that may be useful which gives how to call oracle
stored procedure from ado.net in turn asp.net and also how to use ref cursor
with DataReader and some general features and limitations.

How To Return an Oracle Ref Cursor to a .NET DataReader Object by Using the
..NET Managed Provider for Oracle
================================================== ================================================== ==========================================

http://support.microsoft.com/default...b;en-us;322160
How to call Oracle stored procedures in Visual Basic .NET with the Microsoft
Oracle Managed Provider
================================================== =====================
http://support.microsoft.com/default...b;en-us;321718
Features and limitations of the .NET Managed Provider for Oracle
================================================== ===============
http://support.microsoft.com/default...b;en-us;322158
************************************************** *********************
Mastering .NET Application Development with Oracle
Optimize Result Set Retrieval Using ODP.NET and Ref Cursors
by Mark A. Williams
================================================== =============
http://www.oracle.com/technology/pub...efcursors.html

Bye
Venkat_KL
Nov 23 '05 #2

P: n/a
JV
Thanks, but I think you missed the point of the question. I already know
how to RETRIEVE a cursor parameter (parameterdirection.out). The question
is can ASP.NET pass IN a cursor.

--John
"Venkat_KL" <Ve******@discussions.microsoft.com> wrote in message
news:F6**********************************@microsof t.com...
Hi Dear JV,

here are the some links that may be useful which gives how to call oracle
stored procedure from ado.net in turn asp.net and also how to use ref
cursor
with DataReader and some general features and limitations.

How To Return an Oracle Ref Cursor to a .NET DataReader Object by Using
the
.NET Managed Provider for Oracle
================================================== ================================================== ==========================================

http://support.microsoft.com/default...b;en-us;322160
How to call Oracle stored procedures in Visual Basic .NET with the
Microsoft
Oracle Managed Provider
================================================== =====================
http://support.microsoft.com/default...b;en-us;321718
Features and limitations of the .NET Managed Provider for Oracle
================================================== ===============
http://support.microsoft.com/default...b;en-us;322158
************************************************** *********************
Mastering .NET Application Development with Oracle
Optimize Result Set Retrieval Using ODP.NET and Ref Cursors
by Mark A. Williams
================================================== =============
http://www.oracle.com/technology/pub...efcursors.html

Bye
Venkat_KL

Nov 23 '05 #3

P: n/a
When you use the OleDb providers, you can simply consume the returned ref
cursor as a DataTable.

With the OracleClient provider, you have to specify the ref_cursor as an
output parameter. There is no need to actually consume this parameter, as
you will receive your output through normal means once you send in the
properly named ref cursor output parameter, but the param has to be there to
link the MS world with the Oracle world.

If I remember correctly, the same is true with ODP.NET.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************
"JV" <jo**********@goisc.com> wrote in message
news:eB**************@tk2msftngp13.phx.gbl...
A ref cursor data type can obviously be returned as an output parameter of
a stored procedure, but can an ASP.NET application call an oracle proc that
uses a ref cursor as an input parameter? If so, how? What object do you
pass as that parameter?

We are using System.Data.OracleClient, but if necessary, we might be able
to switch.

Nov 23 '05 #4

P: n/a
The .NET Managed Provider for Oracle supports binding Ref_cursors as output
parameters only. There is no support for Ref_cursors as an input parameter.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************
"JV" <jo**********@goisc.com> wrote in message
news:uN**************@TK2MSFTNGP15.phx.gbl...
Thanks, but I think you missed the point of the question. I already know
how to RETRIEVE a cursor parameter (parameterdirection.out). The question
is can ASP.NET pass IN a cursor.

--John
"Venkat_KL" <Ve******@discussions.microsoft.com> wrote in message
news:F6**********************************@microsof t.com...
Hi Dear JV,

here are the some links that may be useful which gives how to call oracle
stored procedure from ado.net in turn asp.net and also how to use ref
cursor
with DataReader and some general features and limitations.

How To Return an Oracle Ref Cursor to a .NET DataReader Object by Using
the
.NET Managed Provider for Oracle
================================================== ================================================== ==========================================

http://support.microsoft.com/default...b;en-us;322160
How to call Oracle stored procedures in Visual Basic .NET with the
Microsoft
Oracle Managed Provider
================================================== =====================
http://support.microsoft.com/default...b;en-us;321718
Features and limitations of the .NET Managed Provider for Oracle
================================================== ===============
http://support.microsoft.com/default...b;en-us;322158
************************************************** *********************
Mastering .NET Application Development with Oracle
Optimize Result Set Retrieval Using ODP.NET and Ref Cursors
by Mark A. Williams
================================================== =============
http://www.oracle.com/technology/pub...efcursors.html

Bye
Venkat_KL


Nov 23 '05 #5

P: n/a
JV
Thanks, Greg. That was what I expected, but couldn't find actual
information about it.

"Cowboy (Gregory A. Beamer)" wrote
The .NET Managed Provider for Oracle supports binding Ref_cursors as
output parameters only. There is no support for Ref_cursors as an input
parameter.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Nov 23 '05 #6

P: n/a
Hi Dear JV,

one more useful link

How To Retrieve Multiple Ref_cursors from an Oracle Stored Procedure by
Using the .NET Managed Provider For Oracle
================================================== ================================================== ======

http://support.microsoft.com/kb/321715/

bye
Venkat_KL
Nov 23 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.