Procedure Results

Procedures can return either single or multiple rows of data.

Results consisting of a single row of data can be passed back as arguments to the procedure. Results consisting of multiple rows of data are passed back as result sets. Procedures can also return a single value given in the RETURN statement.

• Returning a value using the RETURN statement
  The RETURN statement returns a single integer value to the calling environment, causing an immediate exit from the procedure.
• Ways to return results as procedure parameters
  Procedures can return results to the calling environment in the parameters to the procedure. Within a procedure, parameters and variables can be assigned values using:
• Information returned in result sets from procedures
  In addition to returning results to the calling environment in individual parameters, procedures can return information in result sets. A result set is typically the result of a query.
• Returning multiple result sets
  You can use Interactive SQL to return more than one result set from a procedure.
• Variable result sets for procedures
  The RESULT clause is optional in procedures. Omitting the result clause allows you to write procedures that return different result sets, with different numbers or types of columns, depending on how they are executed.