"Claudio Valderrama C." <cvalde@...> wrote:

>
> If the proc doesn't have a suspend at all, then using it like a table is

an

> error. Probably will upset anyone, but what useful output can the

developer

> get now if he tries to select from a non-selectable stored proc. He will

get

> nothing without any explanations and without any hint the call syntax was
> wrong. I tend to agree with stopping compilation here.

Also agreed.

> Having additional metadata to signal the type of the procedure is fine for
> me. It's a small change, it's easy to detect when creating or altering the
> procedure and doesn't change the current behavior; it only provides more
> information in system tables. I don't understand why people put too much
> effort to resist that little enhancement.

I support this idea, if nothing else (except the point mentioned above) is
changed. I'm also ready to add RDB$PROCEDURE_TYPE to ODS11.


Dmitry