create procedure [DB].<%= name %>(IN parameter int) begin

# your SQL goes here

end;