Valew!!

Bom eu resolvi de outra maneira aqui, é temos uma pesquisa fonetica, onde
ela busca todos valores do in, daí passa para uma função retornar os nomes
daquelas empresa... entendi a sugestão de vc's muito obrigada pelo apoio..
mas conversando aqui com o pessoal, parece que eles vão limitar a quatidade
de registros exibida no relatorio, a query que deu esse erro, era exatamente
e um relatorio..
Agradeço muito atenção..




2009/1/19 Larissa Nandi <[email protected]>

>   Mária,
>
> Boa tarde. Voce poderia criar um tabela e contendo todos os valores do in e
> resolver com join.
> Acredito que seria a forma ideal.
> Abraços,
>
> 2009/1/19 Mária Cristina Silva 
> <[email protected]<mariancristina%40gmail.com>>
>
>
>
> > MÁRCIO OBRIGADA, CONSEGUI VE AQ O QUE ÉRA...
> >
> > Estou com esse erro abaixo, e o curioso que acontece quando passo dentro
> do
> > in os valores abaixo, existe alguma maneira de alterar isso no banco?
> >
> > ORA-01795: o número máximo de expressões em uma lista é de 1000
> >
> > *
> >
> > where* empresased0_.SEQ_EMPRESA *in*
> > (1328025, 1328024, 846700, 686051, 1321314, 1634649, 1321315, 1317306,
> > 1838484, 918663, 1694948, 1328029, 1159832, 1078813, 648829, 1031833,
> > 1609652, 1540537, 1285140, 1609062, 1838331, 766913, 1525782,
> > 1362971, 1549542, 1296742, 937062, 1188853, 678510, 883881, 833224,
> > 888734, 1642832, 824241, 1268193, 1643103, 1505871, 112, 710939,
> > 874009, 909902, 1740311, 712625, 1321316, 872034, 755479, 1740312,
> > 1397862, 1744435, 1764861, 1321317, 1088963, 816512, 1794426, 888936,
> > 1149113, 961543, 1321318, 1240885, 1775903, 949952, 954355, 612208,
> > 1622190, 1321798, 1321801, 1321804, 929392, 815059, 1321802, 1538785,
> > 991160, 775650, 691208, 1321302, 864096, 936600, 1778665, 1321805,
> > 936291, 1089635, 1472653, 929732, 991578, 1297869, 1669032, 761777,
> > 1614151, 628990, 872892, 1571632, 868099, 1034975, 1321310, 1321303,
> > 765534, 1321311, 1226409, 1328034, 1328035, 1328037, 1328030,
> > 1328031, 1328032, 1328033, 1361921, 1381541, 673246, 1177767,
> > 1328036, 1328038, 1328039, 1362422, 1525783, 1328028, 786007,
> > 1328027, 1361388, 1190470, 1328041, 1328026, 938847, 1556790,
> > 1321790, 1460935, 935587, 1034977, 1438768, 966890, 983808, 1485917,
> > 680166, 1321792, 1321793, 1590513, 1730113, 1362441, 649198, 1321794,
> > 952831, 785915, 834320, 1148006, 1714034, 841200, 876930, 1060692,
> > 1681906, 900418, 1362451, 1160959, 1079552, 1738272, 1447069,
> > 1666145, 707514, 1268742, 1800723, 1321796, 847324, 1321795, 881964,
> > 897465, 1193935, 1321800, 619718, 1505927, 891107, 724933, 1650988,
> > 743561, 838643, 1606470, 1321797, 1783776, 1642031, 775160, 966918,
> > 1393854, 840164, 703564, 1518686, 1057431, 1733959, 1109504, 906466,
> > 896218, 1328022, 818237, 625981, 707193, 1239399, 728822, 1134894,
> > 1207043, 774230, 1328020, 1328021, 1255437, 1540363, 1645014, 670114,
> > 1424678, 736902, 884801, 1693467, 1328018, 1328019, 1224974, 1692781,
> > 931991, 1290330, 926782, 1615131, 777097, 1406821, 1206028, 1763272,
> > 1381540, 1844481, 1328023, 1361374, 1202760, 1642303, 1363472,
> > 1834640, 1829253, 778107, 1804344, 834866, 1321313, 1116027, 1186694,
> > 919237, 1217860, 1381542, 1741089, 734129, 1795408, 1328042, 1328044,
> > 1328046, 1328045, 1409356, 831875, 1752382, 1321774, 1321775,
> > 1321791, 735139, 1590702, 995448, 794798, 1324189, 624662, 1564478,
> > 949606, 753725, 714517, 727990, 830318, 971876, 922041, 842973,
> > 228783, 847781, 1114433, 1304482, 40217, 136904, 1325396, 361120,
> > 1768658, 1716706, 1325405, 1479420, 515560, 1176474, 1126191, 402784,
> > 893858, 281851, 323483, 1187152, 771475, 27991, 233051, 1531240,
> > 1167579, 364576, 1606006, 902267, 328425, 1508003, 1455561, 432112,
> > 1159021, 1150226, 1203493, 1216498, 1843805, 1486335, 842338,
> > 1044017, 696615, 1038172, 1202651, 1731990, 1733641, 1277792,
> > 1503691, 476019, 1587426, 1597731, 1199390, 608009, 592102, 561099,
> > 1707425, 1125835, 189456, 867352, 500063, 9103, 652058, 1314822,
> > 1008105, 576532, 650438, 1366587, 1041459, 1679902, 1331964, 1331475,
> > 1696473, 21164, 376766, 442697, 998531, 1026776, 557057, 493577,
> > 1812149, 1642440, 1140283, 613437, 1259895, 1419136, 310435, 575909,
> > 42840, 1835320, 95195, 291071, 1091761, 1580157, 868047, 649639,
> > 1302062, 1355936, 1836729, 681622, 1673274, 353595, 1648736, 1791167,
> > 1558175, 1372400, 1206871, 1541230, 1130117, 827448, 993663, 1363391,
> > 1363396, 1120021, 823868, 196884, 1051595, 600690, 1371420, 1654284,
> > 1770366, 194272, 1332407, 1332941, 1332933, 1332950, 141997, 1368468,
> > 1632602, 472666, 47992, 556296, 20915, 379663, 1330272, 320170,
> > 1506771, 1492510, 1096936, 1545323, 1377676, 1595023, 2091, 1173203,
> > 1070448, 737350, 843939, 806562, 1712234, 1051623, 445225, 1542041,
> > 214377, 357407, 1405993, 506667, 1071397, 1391411, 1552936, 1808138,
> > 544948, 73975, 576658, 330970, 550315, 1812327, 1525568, 1561649,
> > 1757035, 766688, 351186, 1137445, 425671, 170587, 159549, 291814,
> > 601336, 428279, 1353371, 1224050, 1177442, 1315316, 537122, 1365041,
> > 467318, 1059805, 740737, 1080200, 592401, 154002, 249359, 1104682,
> > 1157283, 115188, 1471994, 1499630, 1298961, 194202, 1696733, 482640,
> > 436735, 593643, 339730, 1380296, 394819, 450508, 427013, 326964,
> > 1459234, 161962, 1075639, 1394974, 1046281, 1461237, 389586, 22878,
> > 90807, 1204146, 1645806, 53678, 1237310, 523037, 159205, 489777,
> > 818809, 1620125, 599737, 356784, 362679, 515668, 1356765, 1739638,
> > 144078, 231042, 1089987, 395750, 1567131, 23269, 108626, 16441,
> > 1192277, 1687103, 1522010, 174843, 399351, 1830798, 916553, 735299,
> > 1772957, 1824275, 706390, 453960, 1478868, 249703, 486897, 1733068,
> > 29150, 129867, 573331, 55899, 477778, 109448, 134825, 19855, 531517,
> > 197510, 1161840, 306, 15047, 1079006, 899157, 1444636, 1226051,
> > 1022607, 1465100, 1463154, 1423359, 353393, 523597, 548119, 1112646,
> > 174598, 490613, 833146, 1826383, 1365749, 693922, 1037495, 1119969,
> > 1072505, 1650271, 1007477, 448062, 417140, 1415363, 931777, 355930,
> > 814531, 1246198, 1144522, 158509, 147151, 328193, 441881, 500354,
> > 145664, 1154698, 221631, 370042, 260205, 299923, 984187, 1152533,
> > 460855, 1638044, 52777, 1234529, 38533, 132783, 456494, 568507,
> > 348622, 290088, 272865, 28089, 107064, 23063, 458350, 427066,
> > 1165823, 175541, 23890, 497692, 442142, 487370, 319630, 439238,
> > 905168, 1765643, 326548, 807432, 1097607, 1563006, 1657173, 1521619,
> > 1557312, 608361, 230425, 362748, 1340406, 1541503, 914823, 1446905,
> > 896956, 1191050, 554124, 555935, 909202, 905030, 33337, 481064,
> > 1328399, 1327943, 844220, 1747675, 524984, 1202043, 135113, 204827,
> > 1180330, 833583, 656147, 75446, 29429, 1297806, 112419, 134878,
> > 1685775, 1286053, 1201456, 1081635, 685167, 229959, 1221768, 1480447,
> > 680756, 1721018, 1359867, 912735, 75235, 91305, 313348, 1190711,
> > 1601673, 345781, 1028096, 1004139, 1565165, 1615436, 1027715, 579927,
> > 373073, 60530, 1068218, 60864, 514639, 812001, 1497218, 1702920,
> > 189702, 1585838, 1195315, 1350065, 967725, 400662, 328408, 854483,
> > 388494, 1240296, 796992, 1569172, 927964, 1061201, 531676, 918823,
> > 1759938, 480422, 568360, 494819, 261917, 679523, 1264419, 1273650,
> > 1266059, 1348270, 190333, 1706536, 993871, 765463, 1344262, 928663,
> > 663151, 1510857, 1197115, 874640, 1101717, 1547553, 892502, 1092634,
> > 749019, 946654, 1011921, 824385, 366380, 395153, 31484, 464504,
> > 521861, 1512397, 476788, 1656330, 416210, 1451451, 1478462, 599356,
> > 317643, 306303, 358886, 1384246, 555566, 51585, 987533, 359087,
> > 1752073, 318561, 417205, 1303287, 458575, 1752097, 1172780, 1583954,
> > 1386222, 1190424, 523801, 1136276, 1440247, 1721525, 1450438,
> > 1667210, 549738, 384570, 583525, 1021248, 1391972, 265224, 198463,
> > 567499, 336587, 1660983, 1663750, 8171, 878909, 1137826, 1293199,
> > 12259, 1336665, 1651262, 907868, 686524, 827208, 1115952, 1596883,
> > 1249212, 1593457, 1142938, 1422788, 1140944, 536012, 1373658, 150550,
> > 171789, 1729653, 1799049, 1843193, 574685, 751379, 1326963, 572576,
> > 50971, 55554, 212117, 900857, 469780, 1828275, 69445, 1610671,
> > 1795582, 7960, 1266226, 1547116, 991223, 406528, 525383, 1615143,
> > 568328, 231806, 1121324, 1297233, 398203, 1010519, 278648, 154758,
> > 990039, 280457, 166442, 1041133, 388511, 280503, 117908, 279088,
> > 460137, 570124, 1377239, 1680312, 1130702, 561144, 57048, 1760021,
> > 370390, 374561, 1135655, 279766, 1512577, 1450038, 448181, 429265,
> > 1515850, 1228467, 392080, 34809, 465864, 1475309, 282859, 1372212,
> > 1364021, 1363522, 663392, 1305125, 1308248, 1308249, 1308251,
> > 1618895, 1364042, 1364026, 669471, 634232, 113114, 181559, 322973,
> > 1640632, 1229343, 122944, 554416, 342587, 53121, 457040, 141576,
> > 169952, 108631, 1472012, 74496, 256813, 131436, 103087, 1784906,
> > 999590, 1532029, 1457714, 1551739, 227145, 1271312, 1545715, 198813,
> > 1633534, 500384, 343161, 771243, 832623, 715596, 933746, 1402037,
> > 1457215, 447723, 389867, 379275, 444476, 1615121, 1106223, 1833925,
> > 1405778, 1643361, 1635771, 1110771, 1144825, 426714, 273471, 135479,
> > 522576, 360792, 371598, 1338197, 1533323, 550364, 1040839, 990162,
> > 1523637, 1571371, 1767806, 533027, 1587821, 1577340, 1392040, 389702,
> > 1111495, 1609815, 1829685, 322962, 528339, 1501931, 1384132, 1224607,
> > 1833240, 649999, 24732, 404073, 1081573, 1394164, 1592239, 249834,
> > 871105, 1557667, 479676, 1292370, 248423, 47352, 497821, 1167346,
> > 492293, 839707, 1229542, 1262841, 1578691, 1503022, 348279, 892136, 3227,
> > 267110, 1236784, 571951, 1222498, 45585, 203649, 896941, 586078,
> > 281480, 287124, 1659352, 241298, 1688236, 600917, 1421575, 1695397,
> > 1839744, 1635487, 1579999, 1593499, 1468600, 595254, 110246, 1408116,
> > 1235090, 471452, 29641, 1819373, 1567869, 1439115, 429268, 294568,
> > 408748, 82142, 22402, 675799, 705520, 1126078, 761212, 549200,
> > 1653798, 72071, 570549, 1207489, 1811009, 1681910, 1129646, 1743383,
> > 1350563, 489919, 405924, 1817825, 667613, 827898, 1442330, 1265374,
> > 884036, 1441181, 1244904, 1795366, 670586, 1050564, 73589, 124895,
> > 596106, 295478, 917133, 1381826)
> >
> > [As partes desta mensagem que não continham texto foram removidas]
> >
> >
> >
>
> --
> Larissa Nandi
> ========================
> Analista de Sistemas
> DBA Oracle Trainner
>
> [As partes desta mensagem que não continham texto foram removidas]
>
> 
>



-- 
Abraços,
Mária Cristina
Cel: 031-8883-5543
E-mail: [email protected]
MSN:   [email protected]
-- 
"O começo é a parte mais importante do trabalho."
- Platão


[As partes desta mensagem que não continham texto foram removidas]

Responder a