Re: Cursor in XA help!!!

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Sun, 04 Aug 2002 00:44:47 +0100
Message-ID: <3D4C6AEF.7F677637_at_exesolutions.com>


rayliang wrote:

> Anyone knows if I can keep the cursor open after commiting the transaction.
> I'm using XA and Orcle 8.1.7 in my application. I wanted to commit the
> records one by one, but the cursor was closed once I commit the first record
> (error code = -1002)?????? Thank you
>
> Note: the setting close_on_commit=no
>
> Ray Liang

Turn off, or disable, auto commit.

Daniel Morgan Received on Sun Aug 04 2002 - 01:44:47 CEST

Original text of this message