Result sets
- Last Updated: November 7, 2022
- 1 minute read
- DataDirect Connectors
- JDBC
- Autonomous REST Connector 6.0
- Documentation
In addition to defining output parameters, procedures can return one or more result sets.
When defining a procedure that returns a result sets, you must define the maximum number of
result sets to be returned using the following syntax:
DYNAMIC RESULT SETS <xx>- XX
- is the maximum number of result sets that could be returned by the procedure. The
valid values are from
1to99.
The default is that the procedure does not return any result sets.