Procedure parameters appear as a list in the CREATE PROCEDURE statement.
Parameter names must conform to the rules for other database identifiers such as column names. They must have valid data types , and must be prefixed with one of the keywords IN, OUT or INOUT.