Re: PL/SQL and ARRAYSIZE

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 Mon Jan 10 2000 - 07:56:04 CST