Re: Oracle scheme

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Robert Scheer (rbscheer_at_my-deja.com)
Date: 06/10/04 

Date: 10 Jun 2004 07:42:07 -0700

Hi Roy.

In fact, I made a test using the Oracle Oledb Provider that is
installed with the Oracle 9i Client and it worked to return ref
cursors. And the code is smaller that what I had to code using the
ODP.NET for the same task. But could not get the job done using
Microsoft's Oracle Oledb Provider.

After some tests and researches we decided to use ODP.NET as the
provider to access the Oracle database, mainly because of performance.
But I fear the poor documentation Oracle has available about ODP.NET.

Many thanks for your help.

Robert Scheer

"Roy Fine" <rlfine@twt.obfuscate.net> wrote in message news:<OP70zfPTEHA.2580@TK2MSFTNGP12.phx.gbl>...
> "Robert Scheer" <rbscheer@my-deja.com> wrote in message
> news:cfd22ab6.0406071721.651827df@posting.google.com...
> > rbscheer@my-deja.com (Robert Scheer) wrote in message
> news:<cfd22ab6.0406061015.20065562@posting.google.com>...
> > > Hi.
> > >
> > > I was developing a web application using SQL Server. Suddenly, my
> > > customer decided to use Oracle 8.1.6 as the database. The DBA is
> > > deciding if the application will access a new database or a scheme and
> > > I wiil have to migrate my SqlHelper class to an OracleHelper class.
> > > What is the purpose of an Oracle scheme? Can I access it using the
> > > .NET Oledb Provider?
> > >
> > > Thanks,
> > > Robert Scheer
> >
> >
> > Thanks Roy and Gregory.
> >
> > It seems that can't really use the Oledb Provider. In my researches I
> > found that Oledb does not support Oracle cursors. Can you confirm
> > that?
> > Also, I found that in order to use ODP.NET I need to install the
> > Oracle Client 9 but my database is 8i. Can I use this newer client to
> > access an older database without problems?
> >
> > Thanks,
> > Robert Scheer
>
> Robert -
>
> Someone is giving you bad (or at least incomplete) info - OLEDB does in fact
> support cursors - but it does not support updatable cursors -- all cursors
> from Oracle are Read Only. There is the cursor that is opened with the For
> Update clause, but that is still read only, and its advantage or a standard
> cursor is that it includes the rowid as a hidden column, to be used in the
> UPDATE..FOR CURRENT OF statement.
>
> With respect to ODP.NET - yes you must have Oracle 9iR2 client installed.
> You can still connect and access an Oracle 8i database, but obviously, you
> will only be able to use 8i functionality in that case.
>
> regards
> roy fine

Relevant Pages

  • Re: Oracle scheme
    ... > rbscheer@my-deja.com (Robert Scheer) wrote in message ... > found that Oledb does not support Oracle cursors. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle and PHP with Cursors
    ... we are using Oracle and PHP for a Web application. ... We are using ref cursors to return data from oracle ... every row is request with one call to oracle. ...
    (comp.databases.oracle.misc)
  • Re: Connection to ORACLE: Need some explanations
    ... ¤ ... There is a copy of the oracle client ... Oracle OLEDB Provider is a separate install and it is the one to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection to ORACLE: Need some explanations
    ... ¤ ... There is a copy of the oracle client ... Oracle OLEDB Provider is a separate install and it is the one to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle cursor help
    ... DELETE/WHERE clauses consume too many resources. ... I can also limit the row set up front with a pretty simple WHERE clause -- whatever is more efficient is what I'm aiming for (it wasn't clear to me if limiting up front with WHERE clauses defeated the efficiency of cursors ...) ... Can you work with the parallel options (Oracle Enterprise Edition)? ...
    (perl.dbi.users)