Subject | Re: [firebird-support] Error while trying to create stored procedure - invalid request BLR at offset 218 |
---|---|
Author | Lele Gaifax |
Post date | 2007-11-15T14:38:42Z |
On Thu, 15 Nov 2007 13:48:06 +0100
"Martijn Tonies" <m.tonies@...> wrote:
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.
"Martijn Tonies" <m.tonies@...> wrote:
> > SELECT FIRST 1 ID FROM LOJA INTO EMPRESA;Uhm, AFAICT this isn't correct: ':' is needed only within a *SQL*
>
> Whenever you use (input/output) parameters or variables, you need to
> use a : in front of it.
>
> INTO :EMPRESA;
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.