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...