Re: xml->dml ?

  • From: Chris Stephens <cstephens16@xxxxxxxxx>
  • To: Michael McMullen <ganstadba@xxxxxxxxxxx>
  • Date: Wed, 31 Aug 2005 13:18:53 -0400

On 8/31/05, Chris Stephens <cstephens16@xxxxxxxxx> wrote:
> from what i understand there will be 6 different xml documents that
> will be populating 10 - 20 tables each.  ...it seems like a lot of
> wasted time.
> 
> the guy i'm working with is writing some pl/sql to do this.  with his
> permission, i'll post it when he is done.
> 
> thanks!
> chris
> 
> On 8/31/05, Michael McMullen <ganstadba@xxxxxxxxxxx> wrote:
> > I think you'll have to build it manually. But why not manually? How many xsd
> > do you have coming? One for every insert? One thing to note (9.2), you'll
> > have to do an existsnode on every element because if it's missing from your
> > xml your insert will fail.
--
//www.freelists.org/webpage/oracle-l

Other related posts: