ORA-01467: sort key too long

From: Danijel Stojnic <StojnicD_at_hotmail.com>
Date: Tue, 22 Feb 2000 10:26:19 +0100
Message-ID: <88tkn8$4jc$1@pollux.ip-plus.net>

I have follow problem, when I make crosstable with more then 3 columns, = I get the 'ORA-01467: sort key too long' Error. Anybody know how to solve this problem?

SQL One:
SELECT LANGUAGE_CODE_PK,

min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,1),'')) AS English,
min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,2),'')) AS French,
min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,3),'')) AS German

FROM LANGUAGE_TEXT, LANGUAGE
WHERE LANGUAGE_CODE_PK = LANGUAGE_CODE_FK GROUP BY LANGUAGE_CODE_PK SQL Two:
SELECT LANGUAGE_CODE_PK,

min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,1),'')) AS English,
min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,2),'')) AS French,
min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,3),'')) AS German,
min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,4),'')) AS NewLang,
min (DECODE(LANGUAGE_CODE_FK,LANGUAGE_CODE_FK, =
TRNSLANG(LANGUAGE_CODE_FK,5),'')) AS Japanise

FROM LANGUAGE_TEXT, LANGUAGE
WHERE LANGUAGE_CODE_PK = LANGUAGE_CODE_FK GROUP BY LANGUAGE_CODE_PK Received on Tue Feb 22 2000 - 03:26:19 CST