PL/SQL index-by table - how does it work?

Has anyone used the PL/SQL index-by table? I have a developer who wants to know to if it is better than using nested tables for updates on about a dozen related tables. I've never had any experience with it and don't know how it works, what would be better, etc. I read through a post on AskTom that says it would be better, but the post is 9 years old. Is this still a viable alternative to nesting a dozen tables?

The example code that the developer gave me:

FOR li_rec IN li LOOP

          li_array.EXTEND;

          li_array(li_array.LAST) :=

                 InvoiceLineItem_obj(

This is all he provided. He says our code is just creating oracle objects and passing them back to java where they are instntiated. That's all the information I have from the developer other than "it's taking too long" but no actual information on how long is too long.
--

Sandy
Transzap, Inc.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 06 2011 - 15:25:32 CDT