Re: ODBC Pass Through SQL to Oracle Express 10g

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: joel garry <joel-garry_at_home.com>
</span>
<span id="date"><dfn>Date</dfn>: 3 Jul 2006 13:18:34 -0700</span>
<span id="message-id"><dfn>Message-ID</dfn>: <1151957914.769259.158400_at_m73g2000cwd&#46;<!--nospam-->googlegroups.com>
</span>
</address>

Greg Strong wrote:
<br>
<i class="quotelev1">> On 3 Jul 2006 11:42:10 -0700, "joel garry" <joel-garry_at_home&#46;<!--nospam-->com> wrote:</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev2">> >It refers to</i><br>
<i class="quotelev2">> >Microsoft Knowledge Base Q177138</i><br>
<i class="quotelev2">> >http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177138 which</i><br>
<i class="quotelev2">> >basically says, tough, unless you use the Jet engine.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> After doing a little research I think the fact the transactions running</i><br>
<i class="quotelev1">> consecutively DOES in fact create nested transaction because they</i><br>
<i class="quotelev1">> probably were NOT committed in the back end Oracle DB before receiving</i><br>
<i class="quotelev1">> the additional SQL. Maybe I'll have to try ADO rather than DAO. This</i><br>
<i class="quotelev1">> is an interesting read:</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> http://support.microsoft.com/kb/q187289/</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">> Thanks!</i><br>

That says more or less the same thing as the metalink note.

Note that in the Oracle db DDL does a commit before _and_after the DDL statement. A commit ends a transaction. I suppose various ways of accessing the db have their own idea of what a transaction is and so can create semantic confusion. Oracle has what are called "autonomous transactions" which are outside the scope of the current transaction, so you can do things like DDL without blowing off your current transaction. It becomes important to understand Oracle's notion of concurrency when digging into things like this. You can get to Oracle's docs for free, it <severe understatement> may be worth your time </severe understatement> to read the concepts manual and search for other interesting terms to find things like
<a href="http://download-west.oracle.com/docs/cd/B10501_01/win.920/a97248/ch3.htm#1029118">http://download-west.oracle.com/docs/cd/B10501_01/win.920/a97248/ch3.htm#1029118</a>
(in ch. 3 of Oracle Migration Workbench Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations Release 9.2.0 for Microsoft Windows 98/2000 and Microsoft Windows NT).

jg

--
@home&#46;<!--nospam-->com is bogus.
"Have some more absinthe, Vincent."
"Eh?  You talkin' to me Henri?"


<a href="http://www.signonsandiego.com/uniontrib/20060702/news_1m2fairy.html">http://www.signonsandiego.com/uniontrib/20060702/news_1m2fairy.html</a>

<span id="received"><dfn>Received on</dfn> Mon Jul 03 2006 - 15:18:34 CDT</span>

</div>