Re: Problem in SQL....??

From: <bhutaak_at_my-deja.com>
Date: Fri, 29 Oct 1999 02:04:34 GMT
Message-ID: <7vavbh$roj$1@nnrp1.deja.com>

Hi Bhavesh,
You are right the size of string can be 32k, but when you use order by clause the size of string can not be more then 2000(1990)to be more precise.( this is what I recollect).

Cheer up

Arun

In article <3818C4D8.C6106385_at_Sun.COM>, BHAVESH GOSAR <BHAVESH.GOSAR_at_Sun.COM> wrote:
> Hi,
>
> I have the foll. table
>
> Tab T1 ( x1 varchar2(8), x2 varchar2(2), x3 varcahr2(2),
> x4 number(38), x5 varchar2(2000)
> )
>
> When I do a...
>
> set linesize 2500
>
> select x1 || '~' || x2 || '~' || x3 || '~' || x4 || rtrim(x5) || '~'
> from t1
> order by x1, x2, x3, x4
>
> It gives the foll. error...
> =========
> ERROR:
> ORA-01489: result of string concatenation is too long
> =========
>
> When I remove the Order by Clause...
> It gets some rows and gives me the above error...
>
> I checked ORacle MAnuals...and it syas the MAximum length can be
> 32 KB for a string..
>
> Any Ideas...workaround...??
>
> Thanks,
> Bhavesh Gosar
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 21:04:34 CDT