Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

XMLType in oracle procedure

 
Namrta Pandey
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,

Namrta.
 
Vinod Tiwari
Ranch Hand
Posts: 466
1
IntelliJ IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic