Working under Oracle 8 I have a long text field (type is LONG because varchar
is limited to 4000 characters).

SQL permits to read it with select, but SQL can not update it because it
is limited to 4000 characters in update.
The error is String litteral too long.

I tried to concatenate strings using || but i had: result of string concatenation
is too long.

How can I update this long text field in sql, because I can't use PL/SQL
that permits it?

Thanks. Vincent.