You can't declare @vcErrorMsg as a variable being passed to the proc, then again within the proc. Delete the second one and it should work.