create or replace procedure test(IN param1 varchar(50), OUT param2 varchar(50))
BEGIN
set param2 = 'Oslo';
INSERT into MyTable (Name,Town) VALUES(param1, param2);
END;  

MyTable is a simple database with Name as PKey and Name and Town as text.