Help for this page
use DBD::Oracle qw(:ora_types); ... $sth->bind_param(1,$scode, ORA_NUMBER); or $sth->bind_param(1,$scode, ORA_VARCHAR2);
my $sql = 'SELECT ... FROM ... WHERE temperature = :temperature ...'; ... $sth1->bind_param( ':temperature', $degree_celsius, ORA_NUMBER );