java - what to use parse xml file in oracle -


I need to load and parse this huge XML file in Oracle 11g. I will have a structure like this: 

  & lt; Condition & gt; & Lt; If test = 'check' & gt; & Lt; Name & gt; ABC & lt; / Name & gt; & Lt; / If & gt; & Lt; Rest & gt; & Lt; Name & gt; EFG & lt; / Name & gt; & Lt; / Left & gt; & Lt; / Condition & gt;   
 Based on the applicable 'check', I need to create an object.  
 Earlier I was using LXML in Python. Even before that, I used a DOM based parser in Python, but its performance was poor.  
 In addition, I will have to validate this file before parsing it using the DTI file.  
 So, what is the best option to use while switching to Oracle or maybe I can use it in Java via Java stored functionality.   
 
 
 You may be interested in if you are using 9i or later. DTD validation is supported.

Comments

Post a Comment