HiI have this stored procedure that must have some faults in it beacuse I get this error message when I try to run it..Error message..The XML parse error 0xc00ce502 occurred on line number 1, near the XML text "<ROOT><ARTICLES><ARTICLE TiltID=2 MastID=2 MastLiftID=2 CapacityID=3 /></ARTICLES></ROOT>".Msg 6602, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1The error description is 'A string literal was expected, but no opening quote character was found.'.Msg 8179, Level 16, State 5, Procedure p_BulkInsertTiltValues, Line 14Could not find prepared statement with handle 0.The statement has been terminated.Msg 6607, Level 16, State 3, Procedure sp_xml_removedocument, Line 1sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
My stored procedure...p_BulkInsertTiltValues (@ArticleData ntext) ASDECLARE @hDoc intexec sp_xml_preparedocument @hDoc OUTPUT,@ArticleDataBEGINSET NOCOUNT ON; INSERT INTO tbl_TiltValue_Association(TiltID, MastID, MastValueID, CapacityID) SELECT * FROM OPENXML(@hDoc, 'ROOT/ARTICLES/ARTICLE',1) WITH ( TiltID Int , MastID Int, MastLiftID Int, CapacityID Int ) XMLEmp EXEC sp_xml_removedocument @hDocEND
And this is what I insert..Exec p_BulkInsertTiltValues '<ROOT><ARTICLES><ARTICLE TiltID=2 MastID=2 MastLiftID=2 CapacityID=3 /></ARTICLES></ROOT>'
What am I doing wrong here?Regards