Returning variable result sets from procedures

The RESULT clause is optional in procedures. Omitting the result clause allows you to write procedures that return different result sets, with different numbers or types of columns, depending on how they are executed.

See ”Returning variable result sets from procedures” in SQL Anywhere Server - SQL Usage.

For information about the DESCRIBE statement, see Chapter 1, “SQL Statements,” in Reference: Statements and Options.