SQL query .........too long?

I create a sql query,the length about 4000 bytes,used about 168 Decode function,execute error,is this sql query too long?Does Oracle has sql query length limit?

What is the actual error message? if you could post the error number and message so any one can reply you more efficiently. according to Oracle documentation about DECODE function.

"The maximum number of components in the DECODE function, including expr, searches, results, and default, is 255."

select sum(decode(store_cd,'1024',haibun_num,0)) X0,
sum(decode(store_cd,'1043',haibun_num,0)) X1,
sum(decode(store_cd,'1051',haibun_num,0)) X2,
sum(decode(store_cd,'1053',haibun_num,0)) X3,
sum(decode(store_cd,'1055',haibun_num,0)) X4,
sum(decode(store_cd,'1056',haibun_num,0)) X5,
sum(decode(store_cd,'1058',haibun_num,0)) X6,
sum(decode(store_cd,'1061',haibun_num,0)) X7,
sum(decode(store_cd,'1063',haibun_num,0)) X8,
sum(decode(store_cd,'1069',haibun_num,0)) X9,
sum(decode(store_cd,'1086',haibun_num,0)) X10,
sum(decode(store_cd,'1094',haibun_num,0)) X11,
sum(decode(store_cd,'1095',haibun_num,0)) X12,
sum(decode(store_cd,'1096',haibun_num,0)) X13,
sum(decode(store_cd,'1107',haibun_num,0)) X14,
sum(decode(store_cd,'1108',haibun_num,0)) X15,
sum(decode(store_cd,'1109',haibun_num,0)) X16,
sum(decode(store_cd,'1131',haibun_num,0)) X17,
sum(decode(store_cd,'1133',haibun_num,0)) X18,
sum(decode(store_cd,'1141',haibun_num,0)) X19,
sum(decode(store_cd,'1151',haibun_num,0)) X20,
sum(decode(store_cd,'1162',haibun_num,0)) X21,
sum(decode(store_cd,'1163',haibun_num,0)) X22,
sum(decode(store_cd,'1168',haibun_num,0)) X23,
sum(decode(store_cd,'1176',haibun_num,0)) X24,
sum(decode(store_cd,'1178',haibun_num,0)) X25,
sum(decode(store_cd,'1181',haibun_num,0)) X26,
sum(decode(store_cd,'1184',haibun_num,0)) X27,
sum(decode(store_cd,'1191',haibun_num,0)) X28,
sum(decode(store_cd,'1194',haibun_num,0)) X29,
sum(decode(store_cd,'1200',haibun_num,0)) X30,
sum(decode(store_cd,'1201',haibun_num,0)) X31,
sum(decode(store_cd,'1229',haibun_num,0)) X32,
sum(decode(store_cd,'1238',haibun_num,0)) X33,
sum(decode(store_cd,'1240',haibun_num,0)) X34,
sum(decode(store_cd,'1241',haibun_num,0)) X35,
sum(decode(store_cd,'1245',haibun_num,0)) X36,
sum(decode(store_cd,'1258',haibun_num,0)) X37,
sum(decode(store_cd,'1260',haibun_num,0)) X38,
sum(decode(store_cd,'1270',haibun_num,0)) X39,
sum(decode(store_cd,'1275',haibun_num,0)) X40,
sum(decode(store_cd,'1277',haibun_num,0)) X41,
sum(decode(store_cd,'1279',haibun_num,0)) X42,
sum(decode(store_cd,'1308',haibun_num,0)) X43,
sum(decode(store_cd,'1317',haibun_num,0)) X44,
sum(decode(store_cd,'1322',haibun_num,0)) X45,
sum(decode(store_cd,'1333',haibun_num,0)) X46,
sum(decode(store_cd,'1336',haibun_num,0)) X47,
sum(decode(store_cd,'1363',haibun_num,0)) X48,
sum(decode(store_cd,'1372',haibun_num,0)) X49,
sum(decode(store_cd,'1375',haibun_num,0)) X50,
sum(decode(store_cd,'1379',haibun_num,0)) X51,
sum(decode(store_cd,'1380',haibun_num,0)) X52,
sum(decode(store_cd,'1387',haibun_num,0)) X53,
sum(decode(store_cd,'1391',haibun_num,0)) X54,
sum(decode(store_cd,'1416',haibun_num,0)) X55,
sum(decode(store_cd,'1418',haibun_num,0)) X56,
sum(decode(store_cd,'1424',haibun_num,0)) X57,
sum(decode(store_cd,'1428',haibun_num,0)) X58,
sum(decode(store_cd,'1436',haibun_num,0)) X59,
sum(decode(store_cd,'1440',haibun_num,0)) X60,
sum(decode(store_cd,'1442',haibun_num,0)) X61,
sum(decode(store_cd,'1444',haibun_num,0)) X62,
sum(decode(store_cd,'1446',haibun_num,0)) X63,
sum(decode(store_cd,'1448',haibun_num,0)) X64,
sum(decode(store_cd,'1451',haibun_num,0)) X65,
sum(decode(store_cd,'1452',haibun_num,0)) X66,
sum(decode(store_cd,'1457',haibun_num,0)) X67,
sum(decode(store_cd,'1458',haibun_num,0)) X68,
sum(decode(store_cd,'1465',haibun_num,0)) X69,
sum(decode(store_cd,'1471',haibun_num,0)) X70,
sum(decode(store_cd,'1475',haibun_num,0)) X71,
sum(decode(store_cd,'1479',haibun_num,0)) X72,
sum(decode(store_cd,'1485',haibun_num,0)) X73,
sum(decode(store_cd,'1497',haibun_num,0)) X74,
sum(decode(store_cd,'1500',haibun_num,0)) X75,
sum(decode(store_cd,'1503',haibun_num,0)) X76,
sum(decode(store_cd,'1522',haibun_num,0)) X77,
sum(decode(store_cd,'1528',haibun_num,0)) X78,
sum(decode(store_cd,'1536',haibun_num,0)) X79,
sum(decode(store_cd,'1541',haibun_num,0)) X80,
sum(decode(store_cd,'1554',haibun_num,0)) X81,
sum(decode(store_cd,'1555',haibun_num,0)) X82,
sum(decode(store_cd,'1578',haibun_num,0)) X83,
sum(decode(store_cd,'1585',haibun_num,0)) X84,
sum(decode(store_cd,'1587',haibun_num,0)) X85,
sum(decode(store_cd,'1598',haibun_num,0)) X86,
sum(decode(store_cd,'1610',haibun_num,0)) X87,
sum(decode(store_cd,'1612',haibun_num,0)) X88,
sum(decode(store_cd,'1623',haibun_num,0)) X89,
sum(decode(store_cd,'1625',haibun_num,0)) X90,
sum(decode(store_cd,'1636',haibun_num,0)) X91,
sum(decode(store_cd,'1643',haibun_num,0)) X92,
sum(decode(store_cd,'1644',haibun_num,0)) X93,
sum(decode(store_cd,'1645',haibun_num,0)) X94,
sum(decode(store_cd,'1647',haibun_num,0)) X95,
sum(decode(store_cd,'1652',haibun_num,0)) X96,
sum(decode(store_cd,'1655',haibun_num,0)) X97,
sum(decode(store_cd,'1656',haibun_num,0)) X98,
sum(decode(store_cd,'1657',haibun_num,0)) X99,
sum(decode(store_cd,'1660',haibun_num,0)) X100,
sum(decode(store_cd,'1661',haibun_num,0)) X101,
sum(decode(store_cd,'1664',haibun_num,0)) X102,
sum(decode(store_cd,'1665',haibun_num,0)) X103,
sum(decode(store_cd,'1667',haibun_num,0)) X104,
sum(decode(store_cd,'1668',haibun_num,0)) X105,
sum(decode(store_cd,'1669',haibun_num,0)) X106,
sum(decode(store_cd,'1674',haibun_num,0)) X107,
sum(decode(store_cd,'1676',haibun_num,0)) X108,
sum(decode(store_cd,'1679',haibun_num,0)) X109,
sum(decode(store_cd,'1682',haibun_num,0)) X110,
sum(decode(store_cd,'1685',haibun_num,0)) X111,
sum(decode(store_cd,'1689',haibun_num,0)) X112,
sum(decode(store_cd,'1691',haibun_num,0)) X113,
sum(decode(store_cd,'1697',haibun_num,0)) X114,
sum(decode(store_cd,'1701',haibun_num,0)) X115,
sum(decode(store_cd,'1703',haibun_num,0)) X116,
sum(decode(store_cd,'1707',haibun_num,0)) X117,
sum(decode(store_cd,'1710',haibun_num,0)) X118,
sum(decode(store_cd,'1711',haibun_num,0)) X119,
sum(decode(store_cd,'1714',haibun_num,0)) X120,
sum(decode(store_cd,'1716',haibun_num,0)) X121,
sum(decode(store_cd,'1717',haibun_num,0)) X122,
sum(decode(store_cd,'1721',haibun_num,0)) X123,
sum(decode(store_cd,'1722',haibun_num,0)) X124,
sum(decode(store_cd,'1723',haibun_num,0)) X125,
sum(decode(store_cd,'1730',haibun_num,0)) X126,
sum(decode(store_cd,'1731',haibun_num,0)) X127,
sum(decode(store_cd,'1732',haibun_num,0)) X128,
sum(decode(store_cd,'1735',haibun_num,0)) X129,
sum(decode(store_cd,'1736',haibun_num,0)) X130,
sum(decode(store_cd,'1738',haibun_num,0)) X131,
sum(decode(store_cd,'1740',haibun_num,0)) X132,
sum(decode(store_cd,'1742',haibun_num,0)) X133,
sum(decode(store_cd,'1743',haibun_num,0)) X134,
sum(decode(store_cd,'1749',haibun_num,0)) X135,
sum(decode(store_cd,'1751',haibun_num,0)) X136,
sum(decode(store_cd,'1753',haibun_num,0)) X137,
sum(decode(store_cd,'1757',haibun_num,0)) X138,
sum(decode(store_cd,'1759',haibun_num,0)) X139,
sum(decode(store_cd,'1761',haibun_num,0)) X140,
sum(decode(store_cd,'1764',haibun_num,0)) X141,
sum(decode(store_cd,'1769',haibun_num,0)) X142,
sum(decode(store_cd,'1770',haibun_num,0)) X143,
sum(decode(store_cd,'1771',haibun_num,0)) X144,
sum(decode(store_cd,'1774',haibun_num,0)) X145,
sum(decode(store_cd,'1776',haibun_num,0)) X146,
sum(decode(store_cd,'1779',haibun_num,0)) X147,
sum(decode(store_cd,'1783',haibun_num,0)) X148,
sum(decode(store_cd,'1788',haibun_num,0)) X149,
sum(decode(store_cd,'1789',haibun_num,0)) X150,
sum(decode(store_cd,'1791',haibun_num,0)) X151,
sum(decode(store_cd,'1792',haibun_num,0)) X152,
sum(decode(store_cd,'1794',haibun_num,0)) X153,
sum(decode(store_cd,'1795',haibun_num,0)) X154,
sum(decode(store_cd,'1796',haibun_num,0)) X155,
sum(decode(store_cd,'1797',haibun_num,0)) X156,
sum(decode(store_cd,'1799',haibun_num,0)) X157,
sum(decode(store_cd,'1800',haibun_num,0)) X158,
sum(decode(store_cd,'1801',haibun_num,0)) X159,
sum(decode(store_cd,'1803',haibun_num,0)) X160,
sum(decode(store_cd,'1804',haibun_num,0)) X161,
sum(decode(store_cd,'1805',haibun_num,0)) X162,
sum(decode(store_cd,'1806',haibun_num,0)) X163,
sum(decode(store_cd,'1807',haibun_num,0)) X164,
sum(decode(store_cd,'1810',haibun_num,0)) X165,
sum(decode(store_cd,'1811',haibun_num,0)) X166,
sum(decode(store_cd,'1813',haibun_num,0)) X167,
sum(decode(store_cd,'1814',haibun_num,0)) X168,
sum(decode(store_cd,'1815',haibun_num,0)) X169,
sum(decode(store_cd,'1816',haibun_num,0)) X170,
sum(decode(store_cd,'1821',haibun_num,0)) X171,
sum(decode(store_cd,'1822',haibun_num,0)) X172,
sum(decode(store_cd,'1823',haibun_num,0)) X173,
sum(decode(store_cd,'1824',haibun_num,0)) X174,
sum(decode(store_cd,'1826',haibun_num,0)) X175,
sum(decode(store_cd,'1827',haibun_num,0)) X176,
sum(decode(store_cd,'3014',haibun_num,0)) X177,
sum(decode(store_cd,'3028',haibun_num,0)) X178,
sum(decode(store_cd,'3061',haibun_num,0)) X179,
sum(decode(store_cd,'3064',haibun_num,0)) X180,
sum(decode(store_cd,'9756',haibun_num,0)) X181,
sum(decode(store_cd,'9772',haibun_num,0)) X182,
sum(decode(store_cd,'9773',haibun_num,0)) X183,
sum(decode(store_cd,'9808',haibun_num,0)) X184,
hacyu_no,color_cd,size_cd from siwake_haibun
where hacyu_no='950019'
group by hacyu_no,color_cd,size_cd
order by hacyu_no,color_cd,size_cd

ora-01467:sort key too long

You have only two solutions:
1. reduced the number of columns or groups function involved in the operation
2. create a view then make use of it.

CREATE OR RPLACE VIEW myview AS
SELECT
.....
.....
[your query]
WHERE ......
GROUP BY .....
/

now run the query against this view

SELECT * FROM myview
/

thank you very much