By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create or replace function check_read(in_param varchar(10),
in_sensor varchar(10)) returns decimal(6, 2) deterministic
begin
declare ret decimal(6, 2);
select val into ret from sensors where param = in_param and sensor = in_sensor;
return ret;
end;