Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user defined functions » Result sets


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:

  • the SET statement

  • a SELECT statement with an INTO clause

 Using the SET statement
 Using single-row SELECT statements
 Example 1
 Example 2
 See also