CREATE PROCEDURE name ([parameterlist])[options] sqlcodeIf there is more than one parameter, they must be separated by commas. Each parameter is specified as follows:[IN or OUT or INOUT] parametername datatype