Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IN Clause limitations

Re: IN Clause limitations

From: Jim Kennedy <jim>
Date: Wed, 15 Nov 2006 19:15:27 -0800
Message-ID: <6sWdnalgIc1sS8bYnZ2dnUVZ_tSdnZ2d@comcast.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US