Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Babli
Yak Posting Veteran
53 Posts |
 Posted - 2007-02-08 : 00:01:32
|
| Hi,I have a stored procedure in which I am reading a XML string and populating a table[tblUserListData].I am getting an error while running the stored proc.<StoredProcedure>EXEC sp_xml_preparedocument @docHandle OUTPUT, @ntUserList INSERT INTO tblUserListData ( UserName, JoinDate ) SELECT * FROM OPENXML (@docHandle, 'GPWebUsers/UserDetails/') WITH ( Alias nvarchar(100), JoinDate nvarchar(30) )</StoredProcedure>[ERROR OCCURED]XML parsing error: Expression does not return a DOM node.This is my input XML<GPWebUsers><UserDetails><Alias>aa</Alias><JoinDate>bb</JoinDate></UserDetails></GPWebUsers> |
|
|
|
|
|
XML parsing errror