A script-enabled browser is required for this page to function properly.

Cursor Mode Property

Note:

In Release 5.0 and later, cursor mode is handled automatically by Oracle Forms. This property is now obsolete, and should not be used. In particular, cursor mode should never be set to Close. The following information is provided only for historical and maintenance purposes.

Description

Defines the cursor state across transactions. The cursor refers to the memory work area in which SQL statements are executed. This property is useful for applications running against a non-ORACLE data source.

The following settings are valid for the Cursor_Mode property:

Setting

Description

Open (the default)

Specifies that cursors should remain open across transactions.

Close

Specifies that cursors should be closed when a commit is issued.

Applies to form

Set programmatically

Refer to Built-in

GET_FORM_PROPERTY

SET_FORM_PROPERTY

Default

OPEN_AT_COMMIT

Usage Notes