Re: an issue bound with IN list limit
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: deshpande.subodh@xxxxxxxxx
- Date: Fri, 19 Nov 2010 09:32:30 -0500
"It can be
solved by turning off the KeySchemaTable UseCachingTable flag."
That looks like an application error which gives a helpful hint on how to
set what looks like a Java property to avoid this situation. It's not an
Oracle setting so you are better off looking at the application
documentation to make sure you are setting it properly. I'd also like to
commend the programmer for coding such a helpful exception message.
There are ways to code the SQL to avoid ORA-01795 but sometimes when dealing
with third party application that isn't always an option.
On Fri, Nov 19, 2010 at 9:10 AM, Subodh Deshpande <
deshpande.subodh@xxxxxxxxx> wrote:
> 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
> ==============================
>
Other related posts:
