 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / New Users / December 2004Accessing Oracle Ref cursor with Ole DB provider for Oracle
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 > Hello, > [quoted text clipped - 4 lines] > 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 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? > > Hello, > > [quoted text clipped - 11 lines] > > 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? ¤ 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 ~~~ pclement@ameritech.net 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 > ¤ 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 [quoted text clipped - 8 lines] > Paul ~~~ pclement@ameritech.net > Microsoft MVP (Visual Basic)
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.