Thanks SSC Journeyman, I was working for hours in a similar code and receiving this error:

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

The problem was on the declaration: varchar(400) instead...