Question regarding - 'Parse XML Documents'

[oram]

Hi,

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.

Regards,
M

[Tim...]

Hi.

The bulk-bind will only improve the speed of the inserts, not the parsing of the document. You can see how bulk binds work in 8i here:

http://www.oracle-base.com/articles/8i/ ... nds-8i.php

Cheers

Tim...