300 characters are enough, but meanwhile i extended the field to 3000.
It didn't help.
Also the casts didn't help.
--
Christoph

--- In firebird-support@yahoogroups.com, Magnus Titho
<magnus.titho@...> wrote:

>
> crizoo4712 wrote:
> > CREATE PROCEDURE P_TESTCONCAT
> > AS
> > DECLARE VARIABLE P_TEXT VARCHAR(300) DEFAULT '';
> >
> [...]
> You said your field is 2056 characters wide, but here you declare

it as

> varchar(300)
>
> Additionally, you try to concat strings and other data types - cast

them

> as varchar!
>
>
> --
> Magnus
>