Home -> Usenet -> comp.databases.oracle -> Oracle ERROR while using order by clause

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> 






I´ve got a problem while using something like this:



        select * from table_name order by rowid;



The answer is "buffer overflow. Use SET command to reduce ARRAYSIZE or 
increase MAXDATA. (Default values are ARRAYSIZE=15 and MAXDATA=32767)



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












Original text of this message