Well, you actually answered your own question - 9i is first release
with XML support out of the box. XDK (XML Development Kit) is
available for previous releases though
(http://otn.oracle.com/tech/xml/xdk_plsql/content.html)
and includes XSU (XML SQL Utility) among others. XSU allows you
to retrieve a query result as XML document, and parse XML documents
and insert/update tables from them. It's not that trivial as in 9i, but it
works.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Yavor Ivanov" <yavor_ivanov_at_stemo.bg> wrote in message
news:9588a8de.0207092233.439662be_at_posting.google.com...
> Oracle 9i has one very nice function, called sys_xmlgen. It gives you
> the posibility to get XML-formatted result from a query. Works on 9i
> R1 and R2 (with some ora-600's in R1, but there is walkarroud)
> But when I've tryed to test it on 8i R1 (8.1.5.1.1) it is not
> recognised.
> So when, in fact, the XML suppord bacame native to Oracle?
Received on Wed Jul 10 2002 - 03:27:28 CDT
