在Node.js中读取Oracle数据库中的BLOB

const oracledb = require('oracledb');
const fs = require('fs');

// 设置Oracle数据库连接信息
const dbConfig = {
  user: 'your_username',
  password: 'your_password',
  connectString: 'your_connect_string'
};

async function readBlobFromOracle() {
  let connection;

  try {
    // 连接到Oracle数据库
    connection = await oracledb.getConnection(dbConfig);

    // 准备SQL查询语句
    const sql = `SELECT blob_column FROM your_table WHERE id = :id`;

    // 执行查询
    const result = await connection.execute(sql, [your_id]);

    // 获取BLOB数据
    const blobData = result.rows[0][0];

    // 将BLOB数据写入文件
    fs.writeFileSync('output.jpg', blobData);

    console.log('BLOB data has been successfully read from Oracle database.');
  } catch (error) {
    console.error('Error occurred while reading BLOB data:', error);
  } finally {
    // 关闭数据库连接
    if (connection) {
      try {
        await connection.close();
      } catch (error) {
        console.error('Error occurred while closing database connection:', error);
      }
    }
  }
}

readBlobFromOracle();