Re: ARRAY in PL/SQL ???

A copy of this was sent to "Chow Hoi Ka, Eric" <d951686_at_sftw.umac.mo> (if that email address didn't require changing) On Wed, 23 Jun 1999 08:29:39 +0800, you wrote:

>Hello,
>
>Is it possible to define an ARRAY that can store differnt data type of
>data.
>
>Such as,
>
>declare
>TYPE myArray IS TABLE of some_description INDEX BY BINARY_INTEGER;
>array myArray;
>begin
> array(1) := 'Hello PL/SQL';
> array(2) := 123;
> array(3) := 456.789;
>end;
>
>Is it possible to implemment this ????
>
>
>Best regards,
>Eric

No, there are no heterogenous collections in pl/sql as yet. you would have to use an array of varchar2 and store all of the data in strings.

--
See http://govt.us.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 Thu Jun 24 1999 - 06:17:21 CDT