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@xxxxxxxxxxxxxxxxxxx
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
.

Relevant Pages

  • Re: BizTalk 2004 :: merging a multiple root node message as output
    ... If you really have a legacy system that is not using well-formed xml (or ... > I have a typical xml message as input (single root node) and I need to map ... > to a message which contains multiple root nodes. ...
    (microsoft.public.biztalk.general)
  • Re: FOR XML and performance
    ... return it as XML columns? ... make multiple database calls. ... WHERE personId = People.personId ... FROM EmailAddresses AS ...
    (microsoft.public.sqlserver.xml)
  • Re: Temporary store of XML in SQL Server
    ... XML from there. ... > You should wait and use SQL Server 2005 where this can be easily done. ... >>interface database that could potentially send those changes to multiple ... >>using multiple tables with different table definitions, I wanted to store ...
    (microsoft.public.sqlserver.xml)
  • Re: XmlDocuments LoadXml and concurrency
    ... I'm writing a web services that accesses an xml config file. ... multiple instances of the web service), ...
    (microsoft.public.dotnet.general)
  • Re: How to update using OpenXML in a stored proc?
    ... Say I have an xml doc with multiple sets of nodes, and I want to do multiple ... "Graeme Malcolm" wrote in message ... > (SELECT lastname, firstname, title, hiredate ...
    (microsoft.public.sqlserver.xml)