wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes XML insert in Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "XML insert in Oracle" Watch "XML insert in Oracle" New topic
Author

XML insert in Oracle

Yashwant Palkar
Greenhorn

Joined: Dec 01, 2010
Posts: 20
We are passing following XML structure as VARCHAR2 parameter to procedure.


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
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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

Joined: Oct 06, 2007
Posts: 338
Yashwant Palkar wrote:We are passing following XML structure as VARCHAR2 parameter to procedure.


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
 
Consider Paul's rocket mass heater.
 
subject: XML insert in Oracle