sub dbQuery{ my $query = shift @_; my($database) = "myDB"; my($username) = "username"; my($password) = "password"; my($hostname) = "myHost.com"; my $db = dbConnect($database, $username, $password, $hostname); $query = $db->prepare($query); $query->execute(@_); $query->finish; dbDisconnect($db); } my $gi = "11111111" my $orgName = "some bacteria" my $nc = "NC_000000" my $query = "INSERT INTO ORGANISM ORG_NAME, GI, NC VALUES (?, ?, ?)"; dbQuery($query, $gi, $orgName, $nc);