使用 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
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