Re: Multi-dimensional arrays

On Nov 8, 3:19 pm, DA Morgan <damor..._at_psoug.org> wrote:
> m..._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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Yeah, the 2 one dimensional arrays is one alternative I guess. But I know our PHP guys will not like it, since they have to parse it. The arrays will have to be keyed somehow so I know what row in Array #1 goes with what row in Array #2, unless they are in the same order and have the same indexes, etc.........

John Received on Thu Nov 08 2007 - 15:25:42 CST