Re: 2K Max on text concatination

From: Thor <thor_at_echidna.net>
Date: Wed, 11 Nov 1998 17:04:53 -0800
Message-ID: <72dc3o$7qi$2@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.

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 - 19:04:53 CST