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 XMLType in oracle procedure 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 "XMLType in oracle procedure" Watch "XMLType in oracle procedure" New topic

XMLType in oracle procedure

Namrta Pandey
Ranch Hand

Joined: Jul 22, 2008
Posts: 36
Hi All,

From my Java application I am passing xmltype data to the oracle procedure which is in following format :

Can anybody tell me how to get this xmltype data in the procedure and extract all the values sequentially, as i need these values to be checked in some of my tables one by one.

Thanks in Advance,

Vinod Tiwari
Ranch Hand

Joined: Feb 06, 2008
Posts: 459
I worked in an application which heavily used XML and we used to pass it as CLOB object to database and then convert it to XMLTYPE in database and proceed. Hope this helps.

Vinod Tiwari | Twitter
I agree. Here's the link:
subject: XMLType in oracle procedure
Similar Threads
Hibernate mapping using Oracle XML
problem in parsing an XML using SAX parser.
ORA-21700: object does not exist or is marked for delete
how to use data of type XMLTYPE in database in java
populating jsp page from document object works for one but not multiple elements