title: ODI: Load Data from XML file & insert into Oracle Database
body: <p>I'm newbie at ODI (Oracle Data Integrator) 11g. I have XML file. I need to load data from that XML file into Oracle Database. I'm created project, imported knowledge module, created XML &amp; Oracle model.</p>
  
  <p>Note : My XML File consisted from 40+ table.
  <a href="https://i.stack.imgur.com/wdTZ8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wdTZ8.jpg" alt="here&#39;s my interface"></a></p>
  
  <p><a href="https://i.stack.imgur.com/b2rlY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/b2rlY.jpg" alt="i&#39;m created XML &amp; Oracle Model"></a></p>
  
  <p>Target datastore is only stores 1 table at moment.</p>
  
  <p>Here's my session log: 
  <a href="https://i.stack.imgur.com/ExZ7U.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ExZ7U.jpg" alt="Error Message"></a></p>