Re: Multi-dimensional Array

>>>>> "M" == M <someone_at_microsoft.com> writes:

 M> Thanks.  But I do have a problem in using this because: (1) I need
 M> to have a multi-dimensional array up to 12 parameters; and (2)
 M> It's not easy to proof that the mapping function is 1-to-1.

 M> Thanks.

The solution posted by Ed can be generalized to any dimensional array. In fact, what Ed posted is a basic algorithm covered in most introductory text on data structures and is essentially how most compilers handle multi-dimensional arrays. If you grab yourself a book on data structures, you should have no problem translating the algorithm into plsql and putting that into a package - essentially role your own multi-dimensional array.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!