That is very much like the insert_hash example in the DBI docs. FoxTrotUniform is correct in that if you're just going to throw away a statement handle, you may as well use the do() method, but in this case prepare_cached() (as in the insert_hash example) might be better.