materialization procedures can hit max string length

The concatenations performed to build dynamic sql can become too long for just a string - and by our current rules will be truncated rather than converted to a clob.