XML Validation WITH SQL

Question

Hello, I have created a stored procedure that will return the error of XML schema validation. But ERROR_MESSAGE doesn't display the full message of the error. If I replace ERROR_MESSAGE with THROW then I get the full message but I want to store the error into a string variable and I need full error.

Answer 1

I post my solution:

ALTER PROCEDURE [dbo].[spValidateXMLInvDocByXML] (@XML XML, @stringXML NVARCHAR(MAX) output)
AS BEGIN
SET NOCOUNT ON

DECLARE @x XML(dbo.invoicesDoc)

BEGIN TRY     
	SET @x = @XML;   
END TRY   
BEGIN CATCH     
	SET @stringXML = ERROR_MESSAGE();   
END CATCH    
RETURN;   

END