Receiving Error ORA-04031 when attempting a query
From: Bryant <btolar_at_fedworld.gov>
Date: 22 May 2002 11:33:29 -0700
Message-ID: <b0bb806d.0205221033.605794b8_at_posting.google.com>
Date: 22 May 2002 11:33:29 -0700
Message-ID: <b0bb806d.0205221033.605794b8_at_posting.google.com>
As it stands the query uses an IN and lists several hundred values. If I change the query to use BETWEEN the query runs without error. The question is 'Is there a limit on the number of IN values any single SQL query can use' or 'Is performance so poor when using a large IN statement that you must allocate more memory'? Received on Wed May 22 2002 - 20:33:29 CEST