Click here to Skip to main content
15,945,603 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,
I am passing XML data as string from vb.net.I want read this string and insert data into oracle table.provide a soln
Posted

1 solution

hi,

try this,
VB
Dim strReader As New StringReader(StrXmlValue)
'StrXmlValue is the xml string
Dim xmlreader As New XmlTextReader(strReader)
Dim xmlDoc As New XmlDocument
xmlDoc.Load(xmlreader)


using this XmlDocument object you can read the nodes and attributes of XML data and save it in DB.

refer the link.
http://stackoverflow.com/questions/11102544/how-to-return-multiple-results-with-xmltable[^]
http://www.sqlfiddle.com/#!4/d41d8/932[^]

hope it helps.
 
Share this answer
 
v2
Comments
Vijay Walunj,Navi mumbai 11-Feb-13 4:45am    
thanx frnd.i am passing the string containg xml doc and parsing it to xml in store procedure.Using XMLTable i am able read xmldata with single record but i am not able to get entire data.provide soln.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900