Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning an array from a procedure/ function

Re: Returning an array from a procedure/ function

From: Simon Davies <a_person_uk_at_yahoo.co.uk>
Date: 7 Jul 2003 02:48:23 -0700
Message-ID: <6238724c.0307070148.b56dc11@posting.google.com>


"Ryan" <rgaffuri_at_cox.net> wrote in message news:<mn4Oa.9373$ZT5.3228_at_news2.east.cox.net>...  

> im assuming your coming from an Object oriented backgroudn because
>
> MyArray ARRAY := ARRAY('','','','','','','','','','','','','','','');
>
> as a constructor. its not necessary. Arrays are wrapped in Oracle.
> Initialization is taken care of for you.

OK. I have a function which returns an array working. However the code doesn't work when I use dynamically sized arrays (using array.extend;). This is because the array being returned is a different size to the array which I am assigning the result of the function to. How can I get around this problem?

Cheers,

Simon. Received on Mon Jul 07 2003 - 04:48:23 CDT

Original text of this message

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