### 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();