Advertisement

11.20.2007 at 05:12AM PST, ID: 22972506
[x]
Attachment Details

ORA-01795: maximum number of expressions in a list is 1000

Asked by chaituu in Java Programming Language, Oracle Database

Tags: number, maximum, expressions, list, 1000

i have an application that is running against an oracle10g database.  when i try to perform certain operations in the application, it comes back with the error:

ORA-01795: maximum number of expressions in a list is 1000

then, i look at the sql that is generated and i have:

select <some things> from <table> where <a thing> IN (thing1, thing2, 1000+ more);



can i accomidate more than 1000 expressions in IN clause?if not accomdate in oracle how to write it in java(if there are 5000 records)?Start Free Trial
[+][-]11.20.2007 at 05:19AM PST, ID: 20319344

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.20.2007 at 05:19AM PST, ID: 20319348

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Java Programming Language, Oracle Database
Tags: number, maximum, expressions, list, 1000
Sign Up Now!
Solution Provided By: asvforce
Participating Experts: 3
Solution Grade: A
 
 
[+][-]11.20.2007 at 05:22AM PST, ID: 20319360

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.20.2007 at 05:24AM PST, ID: 20319375

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628