use FW::Database;
use XML::Parser;
.
.# a lot of stuff that constructs $stmt
.
DB_insertdata($stmt, $dbh);
####
package FW::Database;
require Exporter;
use vars qw(@ISA @EXPORT %conf);
@ISA = qw(Exporter);
@EXPORT = qw(
&DB_insertdata
);
sub DB_insertdata
{
my $stmt = $_[0];
my $dbh = $_[1];
my $error = "";
my $sth = $dbh->prepare($stmt) || FW::Utils::handle_dberror("$DBI::errstr", $dbh);
my $rv = $sth->execute() || FW::Utils::handle_dberror("$DBI::errstr", $dbh);
}
####
open (PIPE, "|/usr/local/mysql/bin/mysql -u user database");
print PIPE $stmt;
close(PIPE);