The BNF for CREATE PROCEDURE/FUNCTION is lacking in a couple areas.

1) Need more examples representing the various combinations of statement options

2) Not sure how users should use parameter DIRECTIONs (IN/OUT/INOUT) versus RESULT when defining a procedure that returns a single datatype'd variable?

3) Missing info on what might happen at deployment/run-time if a there are conflicting OUT/RESULT values AND a defined RETURNS TABLE (.....) added? (i.e if both defined who wins, or will deployment fail?