Procedures can return results in the form of a single row of data, or multiple rows. 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 Introduction to procedures.
Returning a value using the RETURN statement
Returning results as procedure parameters
Returning result sets from procedures
Returning multiple result sets from procedures
Returning variable result sets from procedures
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|