Re: Oracle ERROR while using order by clause

From: Scott Urman <surman_at_wwsun10.us.oracle.com>
Date: 3 Aug 1994 17:55:45 GMT
Message-ID: <31oln1$sjf_at_dcsun4.us.oracle.com>


In article <31l72l$c32_at_centaur.eunet.be>, penafeo_at_dg1.eunet.be (E. Alberto Pena Fernandez) writes:
|> 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.

Why are you ordering by rowid? These are generated automaticly, you have no control over it, so you will really not know what order it will come back in. If you order by one of your columns, you will have better luck. You may not be able to order by the varchar2(2000) fields, if they are in fact too long. Received on Wed Aug 03 1994 - 19:55:45 CEST

Original text of this message