Xref: alice comp.databases.oracle.misc:22512
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!news.bctel.net!not-for-mail
From: "Thor" <thor@echidna.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: 2K Max on text concatination
Date: Wed, 11 Nov 1998 17:04:53 -0800
Organization: BCTEL Advanced Communications
Lines: 16
Message-ID: <72dc3o$7qi$2@news.bctel.net>
References: <rKl22.195$i53.77004@client.news.psi.net>
Reply-To: "Thor" <none@none.net>
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-Mimeole: Produced By Microsoft MimeOLE V4.71.1712.3

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...
>
>