Re: an issue bound with IN list limit

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 19 Nov 2010 19:40:46 +0530
Message-ID: <AANLkTimxg2-WcjHWwjfjXnghA89bO7AuOLKeEyJV9xdm_at_mail.gmail.com>



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_at_nordea.com>

> 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_at_nordea.com>
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 19 2010 - 08:10:46 CST

Original text of this message