Accessing Oracle Ref cursor with Ole DB provider for Oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Cedric FABIOUX said:
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.
Click to expand...

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
 
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?
 
¤ 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)
 
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
 
Back
Top