Well, this whole thing is weird.

After changing my procedure to execute block and modifying the SUBSTRING
parameters I got this:

Database Server Error: undefined message number

Nice huh?

On Nov 15, 2007 11:59 AM, Helen Borrie <helebor@...> wrote:

> At 11:41 PM 15/11/2007, you wrote:
> >Hi,
> >
> >I'm trying to create a stored procedure from a delphi application and I'm
> >getting this error:
> >
> >*invalid request BLR at offset 218
> >undefined message number
>
> My eyes are too tired to do the counting, but count the characters from
> the beginning up to the 218th byte and I think you might land in the marked
> place:
>
> >*This is my stored procedure's code:*
> >*
> >VALUES
> > (SUBSTRING(: <--- VENDA_ID FROM 1 FOR 16) || SUBSTRING(:FINANCEIRO_ID
> FROM 17),
>
> If you apply SUBSTRING() to an expression you need an extra pair of
> brackets enclosing the expression, viz.
>
> (SUBSTRING((:VENDA_ID) FROM 1 FOR 16) || SUBSTRING((:FINANCEIRO_ID) FROM
> 17),
>
> Goodnight.
> ./heLen
>
>


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