my $dbh= DBI->connect(............  );

my $sth = $dbh->prepare("call sp_get_workitems (1,1)");
$dbh->begin_work  or die $dbh->errstr;
$sth->execute();
my ($result)= $sth->fetchrow_array();

$dbh->commit;

DBD driver has not implemented the AutoCommit attribute

DBD::mysql::db commit failed: Commands out of sync; you can't run this command now