dbTalk Databases Forums  

PL/SQL How to set Varray elements in a loop

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc PL/SQL How to set Varray elements in a loop

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss PL/SQL How to set Varray elements in a loop in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Norbert Pürringer
 
Posts: n/a

Default PL/SQL How to set Varray elements in a loop - 08-06-2008 , 08:24 AM





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

Reply With Quote
  #2  
Old   
metzguar
 
Posts: n/a

Default Re: PL/SQL How to set Varray elements in a loop - 08-07-2008 , 02:46 AM





On 6 Aug., 15:24, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
Quote:
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/B...s.htm#BABEFDBF

HtH, Urs Metzger


Reply With Quote
  #3  
Old   
metzguar
 
Posts: n/a

Default Re: PL/SQL How to set Varray elements in a loop - 08-07-2008 , 02:46 AM


On 6 Aug., 15:24, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
Quote:
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/B...s.htm#BABEFDBF

HtH, Urs Metzger


Reply With Quote
  #4  
Old   
metzguar
 
Posts: n/a

Default Re: PL/SQL How to set Varray elements in a loop - 08-07-2008 , 02:46 AM


On 6 Aug., 15:24, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
Quote:
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/B...s.htm#BABEFDBF

HtH, Urs Metzger


Reply With Quote
  #5  
Old   
metzguar
 
Posts: n/a

Default Re: PL/SQL How to set Varray elements in a loop - 08-07-2008 , 02:46 AM


On 6 Aug., 15:24, Norbert Pürringer <thalio... (AT) graffiti (DOT) net> wrote:
Quote:
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/B...s.htm#BABEFDBF

HtH, Urs Metzger


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top