Re: Returning CURSORS from ORACLE STORED FUNCTIONS

rpbinphilly wrote: 
But the gist of this is = "Stored Functions are NOT supported via the
Microsoft .NET PRovider? Is that documented anywhere?


http://groups-beta.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/ca07ec86a9613388/3e4cc050d0df3961?q=%22ref+cursor%22+oracleclient+%22oracle+function%22&rnum=1&hl=en#3e4cc050d0df3961

I STRONGLY recommend that you use ODP with the 10g database. There's a *LOT* of new Oracle features that the MS provider can't support.

You should also check out the beta ODP for use with VS 2005.

For earlier versions of Oracle I haven't found a compelling reason to use ODP. This function issue isn't that big of a deal, since there's an easy work-around as Cowboy said.

Eric
.

Relevant Pages

  • Secure connections to oracle
    ... Developing application to talk with Oracle 10g database from Windows platform. ... Connectivity will be used by application to connect to the Oracle DB ... Is the ODP .NET connection encrypted? ... User credentials will have to be 'hard-coded', which means that someone with access to the scripts will be able to extract the UserID/Password to connect to the database. ...
    (Security-Basics)
  • Re: C# and Oracle Problem
    ... greatest security patch. ... The database team rolled back the patch, ... I'm in the process of upgrading to ODP 10.2.0.2.21, ... the SQL queries do work even when the stored procedures do not. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Memory Error?
    ... I ran into same issue and it turns out problem was with ODP.NET installed with the Oracle 10.2 database. ... When you install Oracle 10.2 database, now it includes the 10.2 ODP.NET and somehow it was not going good with .net2.0 and producting above error. ... Once I removed 10.2 ODP.net and use seperate Oracle instller for 10.1.0.4 odp, ...
    (microsoft.public.vsnet.general)
  • concurrency violation
    ... I'm using ODP to access and Oracle 9i database. ... number of DataRows. ...
    (microsoft.public.data.ado)
  • Re: Oracle error when i use System.Data.OracleClient 1.0.5000.0
    ... are in a situation that we cannot move to ODP now. ... and Oracle is trying to automatically recompile it. ... > that is using this package - it might not appear directly in your code. ... > I don't think this particular error has anything to do with the provider ...
    (microsoft.public.dotnet.framework.adonet)