You have to put your prepare out of the while...it's incorrect! :-) It's the power of execute in DBI module: you have a generic statement and then (in the while loop) you use execute with your params! See perldoc DBI...