Thanks, Galen, for your reply.
Please, see my answer to Sybrand Bakker's response. There I explain that
one single question mark stands for just one single parameter.
Regards,
Johannes
Galen Boyer wrote:
> On Tue, 06 Jul 2004, 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'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? If yes, why does this apply to subselects but not
>>to recursion?
>>
>>Any help is greatly appreciated!
>>Thanks in advance,
>>
>>Johannes
>
>
> My guess is that the (?) has more than 1000 in its list.
Received on Wed Jul 07 2004 - 03:07:40 CDT