maximum number of expressions in a list is 1000
From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Wed, 02 Jan 2013 11:00:52 +0100
Message-ID: <50E40554.9070108_at_sferacarta.com>
Hi all,
Date: Wed, 02 Jan 2013 11:00:52 +0100
Message-ID: <50E40554.9070108_at_sferacarta.com>
Hi all,
I'm trying a query like this:
SELECT id, name from anagrafica WHERE id in (100,32,43,66,2,1,334,
...... more than 1000 values)
and I got this error:
cx_Oracle.DatabaseError: ORA-01795: maximum number of expressions in a list is 1000
Is there a workaround to avoid this error in oracle?
j
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 02 2013 - 11:00:52 CET