skip to main content
Part 4: The Connect XE Drivers : The Greenplum Wire Protocol Driver : Connection Option Descriptions : Fetch RefCursors
  
Fetch RefCursors
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