drop function if exists reverseit
//

create function reverseit(param1 varchar(100)) returns varchar(100)
begin
    
    return reverse(param1);
    
end    
//

drop procedure if exists callreversefunc
//

create procedure callreversefunc(INOUT param1 VARCHAR(100))
begin
    
    set param1 = reverseit(param1);
    
end    
//