Re: ORA-01795 although there is just 1 parameter used!

On Tue, 06 Jul 2004 18:08:07 +0200, Johannes Lebek <reply-to-newsgroup_at_domain.com> wrote:

>Hi @ll,
>
>I got the following error on my Oracle 9.2 machine:
>
>java.sql.SQLException: ORA-01795: maximum number of expressions in a
>list is 1000
>
>
>
>However, the statement in question is:
>
>SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, col10,
>col11, col12, col13, col14, col15, col16, col17, col18, col19, col20,
>col21, col22 FROM table START WITH col1 IN (?) CONNECT BY (PRIOR col1 =
>col8)
>
>
>
>The original statement definitely does not have too many parameters.
>Is the problem caused by the RECURSION?

I don't see recursion anywhere. I also don't see the contents of the parameter referred to by the (?) construct. So: who can tell.

>
>I've heard that a subselect like SELECT * FROM table WHERE col1 IN
>(SELECT col2 FROM table) is not affected by the 1000-expressions-limitation.
>Is this true?

Yes.

If yes, why does this apply to subselects but not to
>recursion?
>

explain what your definition of recursion is.

>Any help is greatly appreciated!
>Thanks in advance,
>
>Johannes

--
Sybrand Bakker, Senior Oracle DBA