DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Exception

  1. #1
    Join Date
    Dec 2000
    Posts
    95

    Question SQL Exception

    Hi,

    I got an SQL Exception as follows.


    java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

    What does this mean?

    Thank you in advance

    Srinivas Medukonduru

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You have exceeded the maximum number of IN expressions in a list.

    eg you are attempting someting like the following

    Code:
    SELECT .... WHERE x1 IN(n1,n2,.....,n1001)
    Reduce the number of expressions in the IN list.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width