hi sokolowski, if the values are in sequece/range then use between clause, if their are some groups then use like with or. or use case statement if you are on 9i above. Thanks! Subodh 2010/11/19 Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx> > hi, > > have You ever heard of KeySchemaTable UseCachingTable flag? > We have got a solution to IN list limit (at 1000) that this can be > circumvented by turning off such flag. > I searched db reference, hidden parameters (despite of different > convention), MOS and google - no hits > > > Below citation from support > "the error found: java.sql.SQLSyntaxErrorException: ORA-01795: maximum > number of expressions in a list is 1000 is due to a typical Oracle > limitation of max 1000 expressions in IN(from sql syntax). It can be > solved by turning off the KeySchemaTable UseCachingTable flag." > > Best regards > Remigiusz > > -- > Pole nakazi > > ---------------------------------------------------------------------- > Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx> > pos : DBA at DIiUSI > addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland > phone : +48 58 667 17 43 > mobile: +48 602 42 42 77 > > Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia, > wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod > numerem: 0000021828, > dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku, > VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego, > o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych, > NIP: 586-000-78-20, REGON: 190024711 > -- > //www.freelists.org/webpage/oracle-l > > > -- ============================== DO NOT FORGET TO SMILE TODAY ==============================