drop procedure if exists helloprocedure
//

create procedure helloprocedure(param1 VARCHAR(100),INOUT param2 VARCHAR(100))
begin
    
    set param2 = concat(param1,' ',param2);
    
end    
//