Holdable cursors in Oracle?

From: Hillel Eilat <hillel_at_attunity.co.il>
Date: Wed, 19 Mar 2003 09:55:02 +0200
Message-ID: <b597of$13c$1@news2.netvision.net.il>

Hi There.

Some DBMSs support a feature called "Holdable Cursors".

A holdable cursor is kept open accross transaction boundaries, as opposed to the 'normal' behavior of most known DBMS's.

Example (Oracle/RDB syntax):

SQL> DECLARE EMP_CURSOR TABLE CURSOR WITH HOLD PRESERVE ON COMMIT FOR cont> SELECT * FROM EMPLOYEES;

Is there an equivalent / similar functionaly supported in Oracle?

Your response will be appreciated.

Hillel Received on Wed Mar 19 2003 - 01:55:02 CST