--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> crizoo4712 wrote:
> >
> > In order to be able to return multiple rows, I changed it to:
> > EXECUTE BLOCK returns (out integer)
> > AS
> > BEGIN
> > for select f1 from T2 into out do
> > suspend;
> > END
> > This causes the error "-104 - Token unknown line 5, column 1 ;".
> > Whats up here?
>
> Can you create a stored procedure with the same body?

YES, I CAN! But what do I have to do here?

>
> > 2. The RETURNING CLAUSE for inserts is announced as available in

DSQL

> > and PSQL. The usage in PSQL is no problem.
> > In contradiction to the announced DSQL-Availability it is written

in

> > the Notes, that the INTO part is allowed in PSQL only and

rejected in

> > DSQL (everybody expects this..).
>
> What does everybody expect? The INTO clause is not needed for DSQL

in

> the same way as you just do SELECT instead of SELECT INTO.
>
> > Now..is it available in DSQL or not?
>
> Yes.

But when it's availale in DSQL, where are the returned values placed?
What would be the syntax and where can I receive the returned values?

Regards, Christoph