True, but how can you limit the amount of data fetched by BULK COLLECT
INTO?
Martin
Thomas Kyte wrote:
>
> A copy of this was sent to "Matt Houseman" <mhousema_at_ix.netcom.com>
> (if that email address didn't require changing)
> On Sat, 8 Jan 2000 17:54:42 -0800, you wrote:
>
> >How do I get the value of ARRAYSIZE from within PL/SQL?
> >
> >TIA,
> >Matt
> >
> >
>
> you don't. arraysize is a sqlplus-ism. it tells SQL plus, a client tool, how
> many rows SQLPlus should fetch each time it fetches. Outside of running a query
> in sqlplus, arraysize has *no* effect and is meaningless.
>
> You can array fetch in plsql using dbms_sql -- but then you'll know the array
> size you are using since you will tell us programattically how many rows to
> fetch. In Oracle8i, release 8.1, there is a BULK COLLECT option on static sql
> as well -- there the array size is the size of the result set.
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Tue Jan 18 2000 - 14:06:57 CST
