网上关于pro*c编程的资料很少,不常用的BLOB字段的存取就更少了,这次工作中碰巧需要用到,特意总结成下面的代码,供大家参考!
下面的代码作用很简单:
1、从数据库中取出BLOB字段
2、计算该BLOB字段长度
3、使用循环,将BLOB内容写到本地文件
备注:代码里的变量请根据实际情况调整
#include <oci.h>
#include <string.h>
#include <stdio.h>
#include <stdlib.h>
#include <sqlcpr.h>
#define MAXBUFLEN 5000
EXEC SQL include sqlca;
EXEC SQL include sqlda;
void write_file(char *filename, OCIBlobLocator *blob)
{
EXEC SQL BEGIN DECLARE SECTION;
unsigned char buffer[MAXBUFLEN];
EXEC SQL VAR buffer IS RAW(MAXBUFLEN);
FILE *fp ;
unsigned int offset = 1 ;
int i = 0;
unsigned int nBlobLen = 0;
EXEC SQL END DECLARE SECTION;
// write blob into file
fp = fopen(filename, "w");
if (fp == NULL)
return;
// get blob length
EXEC SQL LOB DESCRIBE :blob GET LENGTH INTO :nB