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

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-dimensional arrays

Re: Multi-dimensional arrays

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 08 Nov 2007 13:19:02 -0800
Message-ID: <1194556737.585939@bubbleator.drizzle.com>


mtek_at_mtekusa.com wrote:

> On Nov 8, 12:07 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> m..._at_mtekusa.com wrote:
>>> Hi Everyone,
>>> We are running Oracle 8.1.7. I'm trying to create a two dimensional
>>> array. I realize that this is almost impossible prior to 9i. But,
>>> this is all I have to work with right now.
>>> Can someone give me an example on how to set this up in a package?
>>> I'm lost and have tried a number of different things.
>>> I'm hoping for something somewhat simple, that will not take 30 lines
>>> of code to implement and use.
>>> Thank you for your help.
>>> John
>> It is also not possible with 11g.
>>
>> You don't need a two dimensional array to solve the problem as you have
>> already been told.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
> 
> 
> Daniel,
> 
> I will be returning X number of rows with Y number of columns for each
> of those rows.  To me, that looks like a 2 dimensional array.....
> 
> John.

One interpretation is a two dimensional array. Another interpretation is two single dimensional arrays. Oracle gives you one of them and not the other.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 08 2007 - 15:19:02 CST

Original text of this message

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