萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

使用 ORADBI 讀取 BLOB 欄位檔案並還原

使用 ORADBI C API 讀取儲存於 BLOB 欄位的多個檔案,還原至指定路徑。完整可編譯範例:

// read_blobfile.c
#define _CRTDBG_MAP_ALLOC
#include 
#include 
#include "../oradbi.h"

#ifdef _DEBUG
#pragma comment(lib, "../oradbi_dll/debug/oradbid.lib")
#else
#pragma comment(lib, "../oradbi_dll/release/oradbi.lib")
#endif

#define ORADB_SERVICE "CHEUNG"
#define ORADB_LOGUSER "mineusr"
#define ORADB_PASSWORD "minepwd"

void select_blob_data() {
  lresult rc;
  ora_error_t err;
  ora_connection con = 0;
  ora_sqlstmt stmt = 0;
  ora_rowset rs = 0;
  ora_column col;
  ora_datetime odt;
  char *psz, buf[30];
  char **pp_fnames = 0;
  ushort num_files = 0, ui;

  rc = ORA_connection_create(&con, ORADB_SERVICE, ORADB_LOGUSER, ORADB_PASSWORD,
                             OCI_THREADED|OCI_OBJECT, FALSE, &err);
  assert(rc==ORC_SUCCESS);

  rc = ORA_sqlstmt_create(&stmt, con,
       "SELECT BM, NAME, BIRTH, DATA FROM TEST WHERE ROWNUM < 2", -1, 0, &err);
  assert(rc==ORC_SUCCESS);

  rc = ORA_sqlstmt_select(stmt, MOD_DEFAULT, &rs, &err);
  assert(rc==ORC_SUCCESS);

  while (ORA_rowset_next(rs)) {
    // BM
    col = ORA_rowset_get_column_by_index(rs, 1, &err);
    ORA_column_as_string(col, &psz, &err);
    printf(" %s ", psz);

    // NAME
    col = ORA_rowset_get_column_by_index(rs, 2, &err);
    ORA_column_as_string(col, &psz, &err);
    printf(" %s ", psz);

    // BIRTH
    col = ORA_rowset_get_column_by_index(rs, 3, &err);
    ORA_column_as_datetime(col, &odt, &err);
    ORA_datetime_to_string(odt, "YYYY-MM-DD HH:UU:SS", buf, &err);
    printf(" %s ", buf);

    // DATA (BLOB) → 檔案
    col = ORA_rowset_get_column_by_index(rs, 4, &err);
    rc = ORA_column_read_lobfile(col, "c:\\temp", &pp_fnames, &num_files, &err);
    assert(rc==ORC_SUCCESS);
    for (ui=0; ui

關鍵 API

  • ORA_column_read_lobfile:直接將 LOB 內容寫入檔案系統,回傳檔名陣列
  • ORA_string_list_free:釋放檔名陣列記憶體
  • 記憶體洩漏檢測:_CrtDumpMemoryLeaks()

資料表結構

CREATE TABLE TEST (
  BM VARCHAR2(10), NAME VARCHAR2(100), BIRTH DATE, DATA BLOB
) TABLESPACE USERS ... STORAGE (MAXEXTENTS UNLIMITED);

原始碼下載:CSDN

copyright © 萬盛學電腦網 all rights reserved