Re: an issue bound with IN list limit
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 19 Nov 2010 15:40:30 +0100
Message-ID: <4CE68C5E.3040105_at_nordea.com>
Andy Klock pisze:
> "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.
>
Date: Fri, 19 Nov 2010 15:40:30 +0100
Message-ID: <4CE68C5E.3040105_at_nordea.com>
Andy Klock pisze:
> "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.
>
I did not think about Java - that is possible, thank You
-- 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-lReceived on Fri Nov 19 2010 - 08:40:30 CST