Returning 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:

  • the SET statement.

  • a SELECT statement with an INTO clause.

 Using the SET statement
 Using single-row SELECT statements
 Notes