my $sql = 'SELECT ... FROM ... WHERE temperature = :temperature ...';
...
$sth1->bind_param( ':temperature', $degree_celsius, ORA_NUMBER );