I was facing the same problem. But I came with a solution. I dont know whether it is correct or not.

create procedure sp_test

@str varchar(8000)

changed to

create procedure sp_test

@str ntext

as

declare...