Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01795 although there is just 1 parameter used!
I'm sorry to have caused that confusion. The statement I is causing this
ORA-01795 really has more than 1000 '?' for bind variables.
The guy who told me, that there is this error, thought noone would mind
if he cuts off the question marks. In his eyes, it is easier to read
short SQL statements. Smart guy!
I apologize for wasting your time.
Johannes
Johannes Lebek 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
Received on Wed Jul 07 2004 - 11:26:37 CDT