Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IN Clause limitations
"Kavita" <kavita.kavitha_at_gmail.com> wrote in message
news:1163624046.648496.170040_at_f16g2000cwb.googlegroups.com...
> is any one knows ....is there any limitations to pass the number of
> total count values not more then 999
>
> where (PC_CONT) IN (" & gc_PolicyNumberString(i_NoOfRecInArr) & ")
>
> where array should not accessed with more then 999 values?
>
> -Kavita
>
You are limited to 1000 items. You can cast to a table then you don't have
a limit.(see asktom.oracle.com)
Jim
Received on Wed Nov 15 2006 - 21:15:27 CST