Re: limits to select/where/in statement??
From: Adrian Billington <adrian.billington_at_virgin.net>
Date: 6 Dec 2001 00:51:59 -0800
Message-ID: <df56145d.0112060051.68b074d2_at_posting.google.com>
Date: 6 Dec 2001 00:51:59 -0800
Message-ID: <df56145d.0112060051.68b074d2_at_posting.google.com>
Actually I think the limit in 8i is 1000 - I seem to remember coming across this problem awhile ago and the documentation being out of date. See the following error message for your answer:-
ORA-01795: maximum number of expressions in a list is 1000
I think you should be OK with 500. Try it !
Adrian Received on Thu Dec 06 2001 - 09:51:59 CET