Subject Re: [firebird-support] Error while trying to create stored procedure - invalid request BLR at offset 218
Author Lele Gaifax
On Thu, 15 Nov 2007 13:48:06 +0100
"Martijn Tonies" <m.tonies@...> wrote:

> > SELECT FIRST 1 ID FROM LOJA INTO EMPRESA;
>
> Whenever you use (input/output) parameters or variables, you need to
> use a : in front of it.
>
> INTO :EMPRESA;

Uhm, AFAICT this isn't correct: ':' is needed only within a *SQL*
statement, while the Firebird PL is tolerant on its usage. The "INTO"
part falls in the latter specifications.

ciao, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
lele@... | -- Fortunato Depero, 1929.