my $sth = $dbh->prepare_cached(<<SQL);
insert into my_table (id, name) values (?, ?)
SQL
$sth->execute('15', 'Foo');