I work primarily with MS SQL. When I want to create a procedure I take an existing procedure and change it. I make the changes to the procedure as I want and then change ALTER to CREATE and execute it.
Apparently it doesn't work the same way. The '@' generates an error if CREATE syntax is used as opposed to ALTER.
I can't find a sample CREATE PROCEDURE with variables being passed.