CREATE PROCEDURE simpleproc2(OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM REGION; END