如何使用Node promises从Oracle返回多个结果集

const oracledb = require('oracledb');

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

    // 在这里执行查询操作

    await connection.close();
    console.log('Connection closed');
  } catch (error) {
    console.error('Error connecting to Oracle Database:', error);
  }
}

connectToOracle();

const oracledb = require('oracledb');

async function executeQuery(connection, query) {
  try {
    const result = await connection.execute(query, [], {
      outFormat: oracledb.OUT_FORMAT_OBJECT
    });
    console.log('Query executed successfully');
    console.log('Result:', result.rows);

    // 在这里处理结果集

  } catch (error) {
    console.error('Error executing query:', error);
  }
}

// 在connectToOracle函数中的"在这里执行查询操作"部分调用executeQuery函数，例如：
// await executeQuery(connection, 'SELECT * FROM table_name');

const oracledb = require('oracledb');

async function executeMultipleQueries(connection, queries) {
  try {
    const result = await connection.executeMany(queries, [], {
      outFormat: oracledb.OUT_FORMAT_OBJECT
    });
    console.log('Multiple queries executed successfully');
    console.log('Results:', result);

    // 在这里处理多个结果集

  } catch (error) {
    console.error('Error executing multiple queries:', error);
  }
}

// 在connectToOracle函数中的"在这里执行查询操作"部分调用executeMultipleQueries函数，例如：
// await executeMultipleQueries(connection, ['SELECT * FROM table1', 'SELECT * FROM table2']);