Re: xml -> dml (/ddl)



bdj wrote:
Hi!
I have to take a xml-document (the same type every time) through a web-service.
Are there tools to generate table-ddl's? (just neede one time)


The xml-document should be "converted", e.g. stored in a set of (normalized)
tables in an Oracle 8.1.7 db :-(

Wich package can I use? Or is there an tool that convert the xml to
table-insert-scripts.

I think I'll be able to handle solutions using PL/SQL, Java or Perl. Perhaps
there is something useful for this kind in JDeveloper?

Greeting & thanks
Bjørn



There was a similar post on AskTom. It might help you:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:27523665852829

Amogh
.



Relevant Pages

  • Re: xml -> dml (/ddl)
    ... but in 8.1.7 there is no xmltype... ... > bdj wrote: ... >> I have to take a xml-document through a ... >> there is something useful for this kind in JDeveloper? ...
    (comp.databases.oracle.misc)
  • xml -> dml (/ddl)
    ... I have to take a xml-document through a ... web-service. ... (just neede one time) ... Prev by Date: ...
    (comp.databases.oracle.misc)