Attribute

FetchRefCursors (FRC)

Purpose

Determines whether the driver returns refcursors from stored procedures as results sets.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver returns refcursors from stored procedures as result sets. The driver fetches all the data from the refcursor and then closes the refcursor. If a stored procedure returns multiple refcursors, the driver generates multiple result sets, one for each refcursor returned.

If set to 0 (Disabled), the driver returns the cursor name for refcursors. The application must fetch the actual data from the refcursor using the cursor name and must close the cursor before additional processing can be done on the statement. The application must close the cursor regardless of whether it actually fetches data from the cursor.

Default

1 (Enabled)

GUI Tab

Advanced tab