use DBI qw(:sql_types); $sth->bind_param( 1, $number, SQL_INTEGER );