Re: PL/SQL bidimensional arrays

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 14 Jul 2001 17:11:59 -0700
Message-ID: <3B50DFCF.B204FE12_at_exesolutions.com>


Fabio Rivieccio wrote:

> Hi everyone!
> Here comes my problem:
> I need to build a bidimensional array as a PL/SQL variable. That is: I need
> to reference each element of the array with
> two numbers (much the same as when I make a C declaration of the kind
> "arrayname[m][n] integer;" to declare an n by m array).
> Moreover I need this to be a variable, I do not want to create any kind of
> table in the DB (table with nested table and so on...).
> Which is the datatype structure I should create?
>
> Thanks for any suggestion.
> Fabio R.

Have you looked at using a PL/SQL table?

Daniel A. Morgan Received on Sun Jul 15 2001 - 02:11:59 CEST

Original text of this message