my $insert_sth = "INSERT INTO some_table (transaction_id, ccn_masked, cardholder_name, exp_month, exp_year, card_type, token_id ) VALUES(?, ?, ?, ?, ?, ?, ? )"; my $q_result = $dbh->prepare($insert_sth) or die "Couldn't prepare statement: " . $dbh->errstr; $q_result->bind_param(1, $txId, { TYPE => SQL_INTEGER } ); $q_result->bind_param(2, $add_data{'maskedccn'}); $q_result->bind_param(3, getCardholderName($self)); $q_result->bind_param(4, getExpMonth($self), { TYPE => SQL_INTEGER }); $q_result->bind_param(5, getExpYear($self), { TYPE => SQL_INTEGER }); $q_result->bind_param(6, getCardType($self)); $q_result->bind_param(7, 5114780000000000271, { TYPE => SQL_BIGINT } ); $q_result->execute()or die "Couldn't prepare statement: " . $dbh->errstr;