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 Stored Procedures and Triggers > Using procedures, triggers, and batches > Returning results from procedures > Returning variable result sets from procedures.