The problem isn't the format of the data (clob vs blob), you just need to specify to SQL that you are working with XML. Try:

DECLARE @xml XML

SELECT @xml =...