an issue bound with IN list limit

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 19 Nov 2010 12:53:23 +0100
Message-ID: <4CE66533.3040904_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
Received on Fri Nov 19 2010 - 05:53:23 CST

Original text of this message