Oracle ERROR while using order by clause
From: E. Alberto Pena Fernandez <penafeo_at_dg1.eunet.be>
Date: 2 Aug 1994 10:27:33 GMT
Message-ID: <31l72l$c32_at_centaur.eunet.be>
Date: 2 Aug 1994 10:27:33 GMT
Message-ID: <31l72l$c32_at_centaur.eunet.be>
I´ve got a problem while using something like this:
select * from table_name order by rowid;
If i set arraysize to 1 and repeat the same SQL query then i got this error:
ERROR: ORA-01467: sort key too long
In the table there are some fields (8) with VARCHAR2(2000), but i´ve only 20 rows in the table. Does somebody know a solution to solve this?
Somebody told me that this is a bug from ORDER BY in such a big fields ( the limit should be aprox. varchar2(980)) Is that true?
Any help will be appreciated.
Thanks in advance.
Received on Tue Aug 02 1994 - 12:27:33 CEST