NIM031527 for No Product Found

Numéro d’ID de bogue	NIM031527
Envoi	January 23, 2008
Dernière modification	April 28, 2025
S’applique à	No Product Found
Version trouvée	9.2
Statut	Known Limit

Informations supplémentaires

No Public Explanation

Solution de contournement

Modify the where clause for your oracle case to use nested queries or joins...Joins would be the fastest - "or" and "in" clauses are normally much slower.Examples:select * from user.Parcels where (PARCEL_ID in (1...1000) orPARCEL_ID in (1001...2000) )=================(select ... from ... where PARCEL_ID in (1, 2, ... 1000) )UNION(select ... from ... where PARCEL_ID in (1001, 1002, ... 2000))...UNION(select ... from ... where PARCEL_ID in (N, N+1, ... M)=================You can use ArcObjects (IDatabaseConnectionInfo2.ConnectionDBMS Property) to determine the type of GDB connected to if needed.