Subject | Re: [Firebird-Architect] Re: Indexed Views |
---|---|
Author | Alexander Klenin |
Post date | 2004-12-22T15:22:14Z |
> > well, this gives some weight to a proposal to throw exception onAnd will silently return empty "resultset" if I forget to add SUSPEND?
> > SELECT from procedures without SUSPEND -- for I have made such mistake
> > more than once.
>
> EXECUTE BLOCK with outputs semantically fully equal to
> SELECT * FROM stored procedure
> If you wish, you may read "doc\sql.extensions\README.execute_block"Thanks, now I understand.
> which is available near the year :
>
> Since EXECUTE BLOCK is generated from client-side it's not needs
> to have default parameters
Actually, I was fooled by similiarity between
CREATE PROCEDURE p (x INTEGER = 1)
and
EXECUTE BLOCK (x INTEGER = ?)
They are, of course, totally different.