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

From: Sandra Becker <>
Date: Wed, 6 Apr 2011 14:25:32 -0600
Message-ID: <>

Version EE

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(li_array.LAST) :=


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.

Transzap, Inc.

-- Received on Wed Apr 06 2011 - 15:25:32 CDT

Original text of this message