Re: Bulk Collect without LIMIT

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 12 Jan 2006 07:28:53 +0100
Message-ID: <43c5f725$0$22657$626a14ce@news.free.fr>

"Andy Hassall" <andy_at_andyh.co.uk> a écrit dans le message de news: t97bs1dtaovvqniit1681su3nob02h5cc9_at_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

You're rigth as PL/SQL tables are indexed by binary_integer/pls_integer that is 32 bit integers.

Regards
Michel Cadot Received on Thu Jan 12 2006 - 00:28:53 CST