Re: Getting started with XML..

Jeremy wrote:
> Simple question: we have an partner who wish to send into our
> application data from their system in the form of an XML document.
>
> We are running Oracle 9i R2 and the Oracle http listener and
mod_plsql.
>
> Our app is built using the web pl/sql toolkit. We would like the
partner
> to send us the the document by making an http call to a proceudre on
our
> server and I assume 'post'-ing the data so that on our side we might
> have a procedure defined as
>
> procedure xml_receiver (p_transaction_id in number,
> p_xml_document in clob)
>
> Am I OK to this point - is this right?
>
> If so, then the next piece of the puzzle is: what tools do we use to
get
> the data values out of the XML document?
>
> Finally, once we have processed the document, if we want send back an

> XML document with status information etc then I assume this can be
> assembled using the various HTP procedures - or is there a less
'home-
> grown' method for returning back an XML document?
>
> Not asking for a solution here just a steer to know the overall
> architecture and toolkit required.
>
> BTW we do not want to get into SOAP and web services - wouldd rather
> keep things 'simple' for now using the existing infrastructure.
>
> --
>
> jeremy

One possible resource is tusc book oracle 9i web development book (brad brown and gang) theres a chapter on xml in there -- that books getting kind of old though. There's a bunch of java based xml processing available inside oracle but I think you can do it all in plsql or maybe you wrap the java up in plsql (sorry outside of what I have done).

And of course all the available doc from otn and tahiti. Received on Fri Feb 04 2005 - 13:29:52 CST