Re: Oracle scheme

From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 06/08/04 

Date: Mon, 7 Jun 2004 21:24:23 -0400

"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 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: Max Cursor error using Oracle
    ... adapter and increasing the OPEN_CURSORS variable to a higher number ... When too many cursors are opened, I receive the max cursor error. ... We are currently using .NET 1.1 and Oracle 9. ... Are you using the Oracle .Net driver, or the one built into VS? ...
    (microsoft.public.dotnet.languages.vb)
  • Oracle Client, stored procedures and Cursor release.
    ... Does anybody know if it possible to force Oracle to release cursors that ... ie My app makes a call that populates a field in a datagrid row ... so it does take more than a few grid refreshes before you hit ...
    (microsoft.public.dotnet.languages.vb)
  • 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)
  • Select random number from a list
    ... I am using Oracle 10g and read about the DBMS_RANDOM and ... clause, but there are times that the query returns no rows. ... Robert Scheer ...
    (comp.databases.oracle.server)