> This is a different thing than above. And AFAIU, it partially
> violates the standard. What's the point in having both CREATE
> FUNCTION and CREATE PROCEDURE if functions can behave as procedures
> and vice versa?

okay, agree. However, create function and create procedure should be
close in definition syntax.

The problem with the current FB situation is that selectable procedures
are essentially functions returning a result set, with the mechanism
abused to implement OUT parameters. Messy.

If we are going to re-architect this area, we might as well think about
the practicallity of cleaning things up:
- selectable procedures becoming selectable functions
- separate mechanism for OUT and IN OUT parameters

Paul