Re: NDS vs DBMS_SQL

Have you looked at doing a multi-table INSERT instead of multiple INSERTs into multiple tables?

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9014.htm#i2163698

This is available in 9i or 10g.

I'm not sure if serializing your data into one XML document is helping or hurting you here. Do you have a need to use XML for this case, outside of this loading process? If not, then XML may be getting in your way. Maybe it isn't.... If you need XML, then look at Oracle's XML toolkits (go to http://technet.oracle.com for many examples). There are tools which let you load from XML files into Oracle databases.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown