Re: Concatenating Very Long Strings

From: Conan <conan_at_>
Date: Tue, 12 Sep 2000 08:58:25 +0100
Message-ID: <bmlv5.22714$r4.12134@news.indigo.ie>

Hi Chris,

the concatenation function returns a varchar2 which has a max length of 2000 in v7 and 4000 in v8 ( I think). So if you are hitting this maximum there are no enviroment variablables you can set to overcome the problem. What you can do is have a look at the utl_file package which will allow write directly to a file from pl/sql. Using the put procedure you can append to file without sending a carriage return so you can create lines of over the maximum varchar2 length

Hth

Conan

Chris Nelson wrote in message <8pjddd$5t1$1_at_nnrp1.deja.com>...
>Hi and thanks in advance.
>
Received on Tue Sep 12 2000 - 02:58:25 CDT