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: PL/SQL and ARRAYSIZE

Re: PL/SQL and ARRAYSIZE

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 18 Jan 2000 20:19:52 -0000
Message-ID: <948227075.11473.0.nnrp-09.9e984b29@news.demon.co.uk>

You can't (yet ?) up to 8.1.5, which is why I still write dbms_sql code to do array fetching if there is any risk of very large result sets being returned.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Martin Haltmayer wrote in message <3884C7E1.A5D82301_at_0800-einwahl.de>...
>True, but how can you limit the amount of data fetched by BULK COLLECT
>INTO?
>
>Martin
Received on Tue Jan 18 2000 - 14:19:52 CST

Original text of this message

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