Re: Cursors / Transactions

From: Komix Hui <huikomix_at_dt.com.hk>
Date: 1997/02/14
Message-ID: <3304A517.74CE@dt.com.hk>#1/1

Rivilis Alexander M wrote:

> Whenever we commit/rollback transactiion --> all open cursors
> are closed(deleted...)
> We are using Visigenic driver to get to oracle database. Currently -- on
> AIX, but plan to go to Sun.
>
> This works fine in Informix (it allows to define cursor behavior --
> stay open or close) on per cursor basis.
>
> Few people told me that Microsoft SQl will just keep cursors open.
>
> Can I get Oracle not to close cursors??? (at least...)

You may try to set initial parameter

CLOSE_CACHED_OPEN_CURSORS = FALSE

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049

Received on Fri Feb 14 1997 - 00:00:00 CST