oracle blob字段 拷贝,我如何从Oracle BLOB字段中提取文件？

您可以使用UTL_FILE包在版本9i开始执行此操作

像这样的东西：

DECLARE

l_file UTL_FILE.FILE_TYPE;

l_buffer RAW(32767);

l_amount BINARY_INTEGER := 32767;

l_pos NUMBER := 1;

l_blob BLOB;

l_blob_len NUMBER;

BEGIN

SELECT blobcol

INTO l_blob

FROM table

WHERE rownum = 1;

l_blob_len := DBMS_LOB.getlength(l_blob);

-- Open the destination file.

l_file := UTL_FILE.fopen(,,'wb', 32767);

WHILE l_pos < l_blob_len LOOP

DBMS_LOB.read(l_blob, l_amount, l_pos, l_buffer);

UTL_FILE.put_raw(l_file, l_buffer, TRUE);

l_pos := l_pos + l_amount;

END LOOP;

-- Close the file.

UTL_FILE.fclose(l_file);

END;

/