XML insert in Oracle

[Yashwant Palkar]

We are passing following XML structure as VARCHAR2 parameter to procedure.

<Customer> <CustomerID><CustomerID> <Firstname> </Firstname> <Lastname> </Lastname> <Address> <CustomerID></CustomerID> <AddressType></AddressType> <Address1></Address1> <Address2></Address2> <City></City> <State></State> <Country></Country> <Pin></Pin> </Address> </Customer>
We want to insert above XML structure in following tables .
Customer (CustomerID is a primary key)
Address (CustomerID references to Customer.CustomerID)

Does Oracle provide any facility which for this?

[Martin Vajsar]

Oracle has XML DB, see if it suits you. I've no experience with it though.

[Paul Campbell]

Yashwant Palkar wrote:We are passing following XML structure as VARCHAR2 parameter to procedure.

<Customer> <CustomerID><CustomerID> <Firstname> </Firstname> <Lastname> </Lastname> <Address> <CustomerID></CustomerID> <AddressType></AddressType> <Address1></Address1> <Address2></Address2> <City></City> <State></State> <Country></Country> <Pin></Pin> </Address> </Customer>
We want to insert above XML structure in following tables .
Customer (CustomerID is a primary key)
Address (CustomerID references to Customer.CustomerID)

Does Oracle provide any facility which for this?

http://www.oracle.com/technology/sample_code/tech/java/codesnippet/xmldb/HowToLoadLargeXML.html