In addition to returning results to the calling environment in individual parameters, procedures can return information in result sets. A result set is typically the result of a query.
The number of variables in the RESULT clause must match the number of the SELECT list items. Automatic data type conversion is performed where possible if data types do not match.
The RESULT clause is part of the CREATE PROCEDURE statement, and does not have a statement delimiter.
The names of the SELECT list items do not need to match those in the RESULT clause.
To modify procedure result sets on a view, the user must have the appropriate permissions on the underlying table.
In the case that a stored procedure or user-defined function returns a result, it cannot also support output parameters or return values.
Interactive SQL displays only the first result set by default. To allow a procedure to return more than one row of results in Interactive SQL, set the Show Multiple Result Sets option on the Results tab of the Options window.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|