Problem: The goal is to do a simple INSERT query using the DBI and sqlite. Everything works as expected when a *single* insert query is submitted. However, when a *compound* query is submitted (using BEGIN TRANSACTION syntax) the attempted operation does not work.

Request: Does anyone have a working barebones snippet of code that shows how to do a compound query using the latest development release of sqlite and perl DBI?

### This code no worky as expected ...
### anyone have a working alternative?

### begin_: init perl
    use strict;
    use warnings;
    use DBI;

### begin_: init vars
    my  $dbh;
    my  $oStt;
    my  $oData;
    my  $sQry000;
    my  $sDbsUrl    = "test.db";

    ### p__: compound INSERT query
    $sQry000    =
    q^
        BEGIN TRANSACTION;
        
        INSERT INTO user ('fname','lname')
        VALUES ('mickey','mouse');
        
        INSERT INTO user ('fname','lname')
        VALUES ('donald','duck');
        
        COMMIT;
    ^;

    ### p__:   run the query
    $dbh    = DBI->connect( "dbi:SQLite:$sDbsUrl" ) 
        || die "Cannot connect: $DBI::errstr";
    $oStt   = $dbh->prepare($sQry000);
    $oStt->execute();
[download]