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.

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

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" <(E-Mail Removed)> wrote in message
news:F613E2A3-C97F-4EF1-A4E4-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:F613E2A3-C97F-4EF1-A4E4-(E-Mail Removed)...
>> 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
>
>

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

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