求助ORACLE 读取BLOB字段问题

Question

要读取一个只有BLOB字段的ORACLE的表   
里面放的是文档   怎样才能把它读出来转换成字符串，希望能给段代码
谢谢

Answer 1

DECLARE
    v_BLOB        BLOB := HEXTORAW('48656C6C6F20776F726C6421');
    v_CLOB          CLOB := 'X';
    v_SQL          ora_name_list_t;
    v_1            PLS_INTEGER := 1;
    v_2            PLS_INTEGER := 1;
    v_lang_context INTEGER := dbms_lob.default_lang_ctx;
    v_warning      INTEGER;
BEGIN
    dbms_lob.convertToClob(v_CLOB,
                           v_BLOB,
                           DBMS_LOB.LOBMAXSIZE,
                           v_1,
                           v_2,
                           dbms_lob.default_csid,
                           v_lang_context,
                           v_warning);
    dbms_output.put_line(v_CLOB);
END;
/
 
Hello world!

Answer 2

不好意思  是我没讲清楚
是VC6.0  OBDC方式读取的问题