Re: HELP!! ORA-00902: invalid datatype

Vince wrote:
> Daniel or others,
>
> Is there an upper limit to worry about with the bulk fetch + related
> processing? Suppose the bulk fetch were 10M rows of about 10k of data
> each? In a case like that, I would probably still write as a cursor +
> loop.
>
> I realize that the answer may be machine dependant as far as SGA or
> memory is concerned, however it seems like there may be an upper limit
> to using the bulk methods.
>
> Vince

There is. And that is why the LIMIT clause exists.

My recollection is that array sizes of 100-250 records often gives the best results. Of course your mileage may vary.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)