my $sth = $db->prepare(q{
    SELECT my_function(:p1, :p2, :p3, :p4) INTO :p5 FROM dual
          });
# bind other params
$sth->bind_param_inout(":p5", \$return_value, 252);