Re: nested loop wiht 2 tables break up
Your outer loop is going through all 17 records, you just can't see it because
when it hits the inner loop for the second time, there is nothing left to fetch!
You fetched all of the records the first time through the inner loop so it will
never be entered again. What you should do is fetch all of the records for the
inner loop into an array once, then iterate through the db1 loop and use this
array for the db2 results. Or else, repeatedly execute the db2 select, but that
is not optimal.
-Dave
Subject
Written By
Posted
Re: nested loop wiht 2 tables break up
October 16, 2006 07:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.