in reply to Perl with Insert query

I think you need a $dbh->commit();

after the execute.

In Section Seekers of Perl Wisdom