Using Procedures, Triggers, and Batches
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. For more detailed information, see the following sections.
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
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.