ContentsIndexPreviousNext

A_ORA_DEFER_CLOSE

This variable determines whether the closing of cursors is deferred or not. Deferring the closing of cursors can result in faster performance when a cursor is re-used, such as on a READ NEXT. Note, however, that this can result in the use of additional Oracle resources, such as memory.

The default value for A_ORA_DEFER_CLOSE is "1" (on, true, yes). If A_ORA_DEFER_CLOSE is set to "0" (off, false, no), cursors are closed as they were in versions of Acu4GL for Oracle earlier than Version 5.2.

Note that this variable can only be set as a configuration variable or an environment variable. It cannot be set programmatically.