Bulk Inserts

Hi,  

  I have following problem scenario .....  

  I have a XML of the format ....
  <Data>
   <Employee>
<EmpName>Kiran</EmpName>
<EmpID>100</EmpID>

   </Employee>
   <Employee>
<EmpName>Faheem</EmpName>
<EmpID>1000</EmpID>

   </Employee>

     ..
     ..
     ..     ..... I have such 30000+ blocks corressponding to 30000+

   Now, I have a DB design with following columns .....

1. EmpName Varchar2(64)
2. EmpID Number(64)

Here I want to parse this XML and persist the data from that XML into DB "efficiently".
I don't want to use conventional INSERTs.  

How can I go about it ?  

Thanks,
--Kiran Received on Mon Dec 15 2003 - 12:02:40 CET