Re: 2K Max on text concatination

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 11 Nov 1998 21:03:34 -0500
Message-ID: <72dgft$9gc$1@inet16.us.oracle.com>

Thor wrote in message <72dc3o$7qi$2_at_news.bctel.net>...

>If you're returning a varchar2 ... the max size of a varchar2 in PL/SQL is
>32767. varchar2 table columns max out at 2000.

2000 in Oracle 7, 4000 if you are using Oracle 8.

chris.

>
>Thor HW
>
>Tom Wolfe wrote in message ...
>>I have a stored procedure that uses a cursor to read columns of data that
>>are 256 bytes, concates them, and returns them as a string. Problem is
>that
>>the data in the table exceeds 2k. Is there a way of accomplishing this in
>>an easy fashion? I am limited to having only one return string.
>>Thanks...
>>
>>
>
>
Received on Wed Nov 11 1998 - 20:03:34 CST