Re: Passing XML to Oracle 9.2

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sat, 17 Jul 2004 01:09:59 GMT
Message-ID: <H%_Jc.59043$eO.26513@edtnps89>

Igordude wrote:

> I am thinking about using XML for passing of a large chunk of
> structured data into Oracle. Later I'd move data from that XML
> structure to relational tables using PL/SQL.
> Is there a straightforward way of doing it besides writing an XML into
> CLOB and then manually parsing data with substr() and instr()?
>

http://otn.oracle.com/tech/xml/index.html

XMLType, PL/SQL & Java Parsers, even a developer's reference document at http://docs.oracle.com

Or you could reinvent the wheel. Received on Fri Jul 16 2004 - 20:09:59 CDT