About half a half-dozen store procedures have similiar problems!
It's definitely a good idea to go through all the store procedures after installation.
Make sure the store procedures code doesn't contain syntax errors!!!
Would it be possible to ask the book author (or somebody else) to update (improve) the sample code.