供参考:
一、写入库:
1、CREATE TABLE html_doc ( docname VARCHAR2(100) PRIMARY KEY,
doc CLOB,
insertdate DATE DEFAULT SYSDATE)
tablespace data02;
2、create or replace DIRECTORY htmldocs AS 'C:\html';
3、CREATE OR REPLACE PROCEDURE insertHTML (dirname IN VARCHAR2,
filename IN VARCHAR2)
IS
htmlfile BFILE;
myclob CLOB;
BEGIN
INSERT INTO html_doc (docname, doc)
VALUES (filename, empty_clob())
RETURNING doc into myclob;
-- get a handle to the html file on the OS
htmlfile := Bfilename(dirname,filename);
-- open the file
DBMS_LOB.fileOpen(htmlfile);
-- copy the contents of the file into the empty clob
DBMS_LOB.loadFromFile(myclob, htmlfile, dbms_lob.getLength(htmlfile));
END insertHTML;
4、EXEC insertHTML('HTMLDOCS', 'test.html');
检测是否已经将该文件存入到clob字段中。
5、select dbms_lob.getlength(doc) from html_doc;
二、从库读出:(看看这篇文章吧)
http://www.chinaunix.net/bbsjh/8/2732.html