Re: Bulk Collect without LIMIT

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 12 Jan 2006 00:06:56 +0000
Message-ID: <t97bs1dtaovvqniit1681su3nob02h5cc9@4ax.com>

On Wed, 11 Jan 2006 18:20:07 +0100, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

>"raghu" <raghu_vnin_at_yahoo.com> a écrit dans le message de news: 1136999673.981564.109260_at_g14g2000cwa.googlegroups.com...
>| 1. What happens if the limit option is not specified in the bulk
>| collect? Are all the records fetched at once?
>| 2. Is there a limitation in terms of maximum number of records that can
>| be fetched in this way?
>
>1. Yes
>2. Process memory

There might also be an upper limit of 2147483647 rows according to the bit in the PL/SQL manual about collection type numeric subscript limits.

Process memory is probably the earlier limit though..!

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Wed Jan 11 2006 - 18:06:56 CST