xml -> dml (/ddl)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bdj - 27 Sep 2005 19:13 GMT

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

Reply to this Message

amogh - 28 Sep 2005 08:29 GMT

> Hi!
> I have to take a xml-document (the same type every time) through a
[quoted text clipped - 12 lines]
> 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

Reply to this Message

bdj - 30 Sep 2005 12:45 GMT

Hi!
Yes, but in 8.1.7 there is no xmltype... :-(
/Bjørn

>> Hi!
>> I have to take a xml-document (the same type every time) through a
[quoted text clipped - 18 lines]
>
> Amogh

Reply to this Message