Subject Re: [firebird-support] Error while trying to create stored procedure - invalid request BLR at offset 218
Author Fabio Gomes
Problem solved.

It was the driver, I installed a third party driver and it worked on the
first try.

Thanx, and sorry for bottering you. :(

On Nov 15, 2007 12:42 PM, 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.
>
> That is correct, you only need to use : when using them in SQL, I meant
> to say that but cut short my sentence, thanks for clarifying this :-)
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
> &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>


[Non-text portions of this message have been removed]