Procedure Results

Procedures can return results of 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.

For simple examples of how to return results from procedures, see . For more detailed information, see the following sections.

• 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.
• Returning Results as Procedure Parameters
  Procedures can return results to the calling environment in the procedure's parameters.
• Returning Result Sets from Procedures
  Result sets allow a procedure to return more than one row of results to the calling environment.
• Returning Multiple Result Sets from Procedures
  A procedure can return more than one result set to the calling environment.
• Returning Variable Result Sets from 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.