Re: an issue bound with IN list limit

  • From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
  • To: "Subodh Deshpande" <deshpande.subodh@xxxxxxxxx>
  • Date: Fri, 19 Nov 2010 15:34:14 +0100

Subodh Deshpande pisze:
> 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.


This is not about how to make it another way, as we have no ability to
change the code. The application in use is AFAIK Oracle BPM or something.

This is if there are somewhere in an Oracle database such flags or flag.
The support said that DBA should know and I do not know... That is why I
ask You :-)

Regards
Remigiusz


> 
> 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
>>
>>
>>
> 
> 


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


Other related posts: