skip to main content
Connection Option Descriptions : Procedure Returns Results
  

Try DataDirect Drivers Now

Procedure Returns Results

Attribute

ProcedureRetResults (PRR)

Purpose

Determines whether the driver returns result sets from stored procedures/functions.
See "Support of Materialized Views" for details.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver returns result sets from stored procedures/functions. When set to 1 and you execute a stored procedure that does not return result sets, you will incur a small performance penalty.
If set to 0 (Disabled), the driver does not return result sets from stored procedures.

Notes

*This connection option can affect performance.

Default

0 (Disabled)

GUI Tab

Advanced tab

See also

Performance Considerations