Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can Ora 8i Write and Read XML data?
FC wrote:
> Well, I just began doing some experiments, but I can confirm that you can
> successfully transform a properly formatted XML document into a recordset
> and load it into a db table using XSU.
> You can also invoke the utility from the command line in the form:
> java OracleXML putXML -user "usr/pwd" -fileName "data.xml" "test_table"
>
> For instance, if oracle_table is defined like
>
> CREATE TABLE test_table (name VARCHAR2(10), title VARCHAR2(30));
>
> then you xml file must look like:
>
> <?xml version = '1.0'?>
>
> <ROWSET>
>
> <ROW num="1">
>
> <NAME>ASR</NAME>
>
> <TITLE>A.S. ROMA</TITLE>
>
> </ROW>
>
> <ROW num="2">
>
> <NAME>ACE</NAME>
>
> <TITLE>ACEA</TITLE>
>
> </ROW>
>
> </ROWSET>
>
> If the input file is still XML but with a different format, say the tags are
> called differently, then you must transform the document upfront using an
> XSLT transformation.
>
> I didn't check the performance aspects yet, may be they are reasonable only
> for limited quantities of data, but I am currently working on this stuff in
> my spare time.
>
> Bye,
>
> Flavio
>
>
Thanks - and my mistake; I meant XSQL (and also abbreviated from XML SQL
Utillity: XSU). I haven't been doing much with XSQL yet, but have not
seen a proper way to do updates.
Nice for display (in conjuction with XML stylesheets) or data exchange
(w/o the stylesheet)
-- Regards, Frank van BortelReceived on Sat Apr 26 2003 - 12:36:27 CDT