Attribute

FetchRefCursor (FRC)

Purpose

Determines whether the driver returns refcursors from user-defined functions as results sets.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver returns refcursor from user-defined functions as result sets. The driver fetches all the data from the refcursor and then closes the refcursor. If a user-defined function 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 refcursor. 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