一万多长度的字符串存oracle,请教超过4000的字符串存储问题？

供参考：

一、写入库：

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