Re: PL/SQL How to set Varray elements in a loop

From: metzguar <urs_at_ursmetzger.de>
Date: Thu, 7 Aug 2008 00:46:23 -0700 (PDT)
Message-ID: <dc5a174c-3fbb-4199-a8e8-d2a4b1683b85@b1g2000hsg.googlegroups.com>


On 6 Aug., 15:24, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> Hello,
>
> is it possible to set the elements of a VARRAY in a loop instead of
> initializing it in one step?
>
> Does anyone have a sample for me?
>
> Is it possible to resize the VARRAY dynamically?
>
> Thank you,
> Norbert

It's in the docs:

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/collections.htm#BABEFDBF

HtH, Urs Metzger Received on Thu Aug 07 2008 - 02:46:23 CDT

Original text of this message