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

Home -> Community -> Usenet -> c.d.o.server -> Do 'sort key too long' error depends on values supplied to query?

Do 'sort key too long' error depends on values supplied to query?

From: Sameer <dolpheen_at_gmail.com>
Date: 27 Nov 2006 02:09:47 -0800
Message-ID: <1164622186.947577.27890@14g2000cws.googlegroups.com>


 Please have a look at this query (Just given for guessing complications).
This query works and gives output for pro_id=1 and other few values. But it fails for value 2.

SELECT *
FROM common_list_view_test
WHERE che_id != 14
 AND(use_id = 299 OR iss_rec = 299 OR che_id IN   (SELECT a.m_che_id
   FROM m_chk_pt a, m_role_chk_pt b, m_user c    WHERE a.m_che_id = b.m_che_id
   AND b.m_rol_id = c.m_rol_id
   AND c.m_use_id = 299))
AND pro_id = 2
ORDER BY iss_dat,
  issue_string

For pro_id = 2 it gives error:
ORA-01467: sort key too long

What do we mean by sort key?
Is it depends on supplied information and the records to be fetched. If the query is going to fetch a lot of records then do this error occur?

How to avoid this error and make the query to work got pro_id=2.

-Sameer Received on Mon Nov 27 2006 - 04:09:47 CST

Original text of this message

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