This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 3606
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: XML insert in Oracle
 
Similar Threads
Java - Mysql connectivity
UPDATE multiple columns with subquery
[Hibernate] How do you map value objects?
Hibernate inserting man-to-one fails
NPE