mtek_at_mtekusa.com wrote:
> 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 Group
>> www.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
They think a database is just a bit bucket. This will just fit nicely
with their prejudice. Let 'em cache it on the app server anyway they
want it.
--
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 - 16:49:07 CST
