Accessing Oracle Ref cursor with Ole DB provider for Oracle

[Guest]

Hello,

I'd like to know, if it is possible, how I could access a ref cursor,
returned by an Oracle stored procedure, in my VB.net application using the
OledbCommand component.
My problem is that the type "OracleType.Cursor" isn't available for the
Oledb command, so I don't know wich type I can use for my OUTPUT parameter
that receive the Cursor.

Thank you for your help

Cedric FABIOUX

 

[David Browne]

Hello,

I'd like to know, if it is possible, how I could access a ref cursor,
returned by an Oracle stored procedure, in my VB.net application using the
OledbCommand component.
My problem is that the type "OracleType.Cursor" isn't available for the
Oledb command, so I don't know wich type I can use for my OUTPUT parameter
that receive the Cursor.

I don't believe the OleDB provider supports ref cursors. In any case OleDb
is probably the worst provider to use for Oracle.

Use OracleClient or or ODP.NET for ref cursor support.

David

 

[Guest]

My problem is that, for logistic reasons, we can not have the Oracle Client
software installed on the client computers. We can only acces the server by
SqlNet. What can I do?

 

[Paul Clement]

¤ My problem is that, for logistic reasons, we can not have the Oracle Client
¤ software installed on the client computers. We can only acces the server by
¤ SqlNet. What can I do?
¤

Sql*Net *is* the Oracle client software. You can't connect to Oracle directly without the client
software or a third-party solution.

If you're using version 9i or higher you can use ODP.NET (Oracle's .NET provider).


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Guest]

You've resolved the problem. We had a 7.X client installed and the provider
could not see it. Now we've installed a 8.X client and it works.

Thank both of you for your help