Cursors / Transactions

From: Rivilis Alexander M <rivilisa_at_odo.msoe.edu>
Date: 1997/02/11
Message-ID: <Pine.OSF.3.95.970211150703.27760A-100000@odo.msoe.edu>#1/1

Hello, everybody!

I am new to Oracle (but not to databases). The following seems like Oracle behavior to me:

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...)

Your help is appreciated.

My e-mail is rivilisa_at_odo.msoe.edu

Thanks in advance,
Alex Received on Tue Feb 11 1997 - 00:00:00 CST