PL/SQL index-by table - how does it work?
- From: Sandra Becker <sbecker6925@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Apr 2011 14:25:32 -0600
Version EE 10.2.0.4
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.
Other related posts:
