Re: SQL statement is to large, and creates a error

jimi_xyz_at_hotmail.com schrieb:

> NOTE: There is about 1884 values within the IN () function. AND..

>
> Any help/ideas will do.
>
> Thanks Inadvance
> Jimi
>

Maybe this helps
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions014.htm#sthref2245

<quote>
A comma-delimited list of expressions can contain no more than 1000 expressions. A comma-delimited list of sets of expressions can contain any number of sets, but each set can contain no more than 1000 expressions. </quote>

Best regards

Maxim Received on Thu Nov 03 2005 - 10:56:39 CST