无法使用executeMany()插入到具有Node.js的Oracle DB中

npm install oracledb

const oracledb = require('oracledb');

async function connectToDB() {
  try {
    const connection = await oracledb.getConnection({
      user: 'your_username',
      password: 'your_password',
      connectString: 'your_connect_string'
    });
    console.log('Connected to Oracle Database');
    return connection;
  } catch (error) {
    console.error('Error connecting to Oracle Database', error);
  }
}

const connection = connectToDB();

const sql = `INSERT INTO your_table (column1, column2, column3) VALUES (:1, :2, :3)`;
const data = [
  [value1, value2, value3], // 第一行数据
  [value4, value5, value6], // 第二行数据
  // 可以继续添加更多行数据
];

async function insertData(connection, sql, data) {
  try {
    const result = await connection.executeMany(sql, data);
    console.log(`${result.rowsAffected} rows inserted`);
  } catch (error) {
    console.error('Error inserting data', error);
  } finally {
    await connection.close(); // 关闭数据库连接
  }
}

insertData(connection, sql, data);