1. Have you tried your code? If you have, what error(s) did you run into?
2. Your code does not compile as written. Your double-quotes aren't doing what you think they're doing. Did you cut'n'paste or retype?
3. Not every database can handle multiple SQL statements. Not every DBD can handle multiple SQL statements, even if the database can. What database are you using?

I have tried the statements and get an error stating, "Can't call method "execute" on an undefined value". I assembled the sql by looking at examples. I am using an access database.

Check if your prepare method call fails, and if so, see what the error is:

my $loadHandle = $dbh->prepare("$sql; $nextsql; $lastsql")
  or die "Couldn't prepare statement: ",$dbh->errstr,"\n";
[download]

I have the feeling that you are using the wrong approach.

What about using an array of values and just one SQL statement with placeholders?

my @values = 
    ( 
        [ 1, 2, 3 ],
        [ 4, 5, 6 ],
        [ 7, 8, 9 ],
        [ 'a', 'b', 'c' ]
);

my $sql = "Insert into tableone values(?, ?, ?);

my $loadHandle = $dbh->prepare($sql);

for (@values)
{
    $loadHandle->execute(@$_)  
        or die "Could not execute SQL statement $sql "
            . " with values ( @$_ )... $DBI::errstr\n ";
}
[download]

However, if what you want to do is execute different statements, here's another way:

my @SQL_statements = (
  "create table x(i int)",
  "insert into x values (1)",
  "update x set i = i * 10 "
);

$dbh->begin_work();
for (@SQL_statements)
{
    eval { $dbh->do($_)};
    if ($@)
    {
        $dbh->rollback();
        die "error executing query '$_', $DBI::errstr\n";
    }
}

$dbh->commit();
[download]

Thanks everyone and a special thanks to dbwiz for coming up with the solution that worked for me. doyle

The sql is generic enough... Perhaps this would work better for you:

my $sql = "Insert into tableone values('1', '2', '3')";
my $nextsql = "Insert into tabletwo values('4', '5', '6')";
my $lastsql = "Insert into tablethree values('7', '8', '9')";

my $loadHandle = $dbh->prepare("$sql; $nextsql; $lastsql;");
  
$loadHandle->execute or
  die "Could not execute SQL statement ... maybe invalid?";
....
[download]

even better:

my $sql = <<EO_SQL;
 insert into tableone values('1', '2', '3')
 insert into tabletwo values('4', '5', '6')
 insert into tablethree values('7', '8', '9')
EOF_SQL

my $loadHandle = $dbh->prepare($sql);
  
$loadHandle->execute or
  die "Could not execute SQL statement $sql ... maybe invalid?";
....
[download]

Jason L. Froebe

Thanks Jason, when I run this code...

$sql = <<EO_SQL;
 insert into tableone values('1', '2', '3')
 insert into tabletwo values('4', '5', '6')
 insert into tablethree values('7', '8', '9')
EOF_SQL

my $loadHandle = $dbh->prepare($sql);
  
$loadHandle->execute or
  die "Could not execute SQL statement $sql ... maybe invalid?";
[download]

I get an error stating, "Can't find string terminator "EO_SQL" anywhere before EOF"

There's a typo. Change:

$sql = <<EO_SQL;
[download]

to:

$sql = <<EOF_SQL;
[download]