This question is in regard to Tim's article 'Parse XML Documents' (http://www.oracle-base.com/articles/8i/ ... nts-8i.php
We have developed the program in Oracle 8i using the method mentioned in the link however we are facing some performance issues when the records in the XML file increase in number.
In this article it has been mentioned that ' -- Form better performance multiple collections should be used to allow bulk binding using the FORALL construct but this would make the code too long-winded for this example.'. Can somebody provide me with an example where FORALL construct has been used and is giving a good performance.
Thanks in advance.