use DBI qw(:sql_types); ..... $sth->bind_param(1,undef,SQL_....); $sth->execute();