Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can we have any correlation between ODBC & OCI transaction openning modes?

Re: Can we have any correlation between ODBC & OCI transaction openning modes?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 6 Mar 2006 08:19:53 -0800
Message-ID: <1141661993.658999.302520@u72g2000cwu.googlegroups.com>


RamaKrishna Narla wrote:
> The SQL_TXN_SERIALIZABLE transation isolation mode of ODBC is something
> similar to OCI_TRANS_SERIALIZABLE mode in OCI.
> Similarly do we have any modes in OCI, which corresponds to the
> isolation levels SQL_TXN_READ_UNCOMMITTED, SQL_TXN_READ_COMMITTED and
> SQL_TXN_REPEATABLE_READ of ODBC?
> And what are ODBC equivalents for OCI_TRANS_READWRITE,
> OCI_TRANS_READONLY and others of OCI?
>
> A quick response would be helpful to me.

Perhaps you can explain in detail what those ODBC modes you are referring to mean and what implications if any an ODBC transaction implies.

Oracle supports transactions and by default delivers read committed data. Received on Mon Mar 06 2006 - 10:19:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US