Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem in SQL....??

Problem in SQL....??

From: BHAVESH GOSAR <BHAVESH.GOSAR_at_Sun.COM>
Date: Thu, 28 Oct 1999 14:49:12 -0700
Message-ID: <3818C4D8.C6106385@Sun.COM>


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 Received on Thu Oct 28 1999 - 16:49:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US