Problem in SQL....??

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

Hi,

[Quoted] I have the foll. table

[Quoted] Tab T1 ( x1 varchar2(8), x2 varchar2(2), x3 varcahr2(2),

         x4 number(38), x5 varchar2(2000)
       )

[Quoted] 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 - 23:49:12 CEST