Currently I'm using the schemavalidate to check whether a XML is valid or not.
But as far as I know, the procedure will fail immediately when it finds the first discrepancy.
And I'm capturing the error using SQLERRM.
But I'm looking for a way to capture all the errors in a XML instead of capturing the first error alone.
Please help me on this issue.