oraclE中读取clob时出错大家帮忙

c1.getSubString((long)1,c1.length());
报错类型长度大于最大值
我不清楚怎么回事,

大家帮忙看看
---------------------------------------------------------------

GETLENGTH Function
This function gets the length of the specified LOB. The length in bytes or characters is returned.

The length returned for a BFILE includes the EOF, if it exists. Any 0-byte or space filler in the LOB caused by previous ERASE or WRITE operations is also included in the length count. The length of an empty internal LOB is 0.

Syntax
DBMS_LOB.GETLENGTH (
lob_loc IN BLOB)
RETURN INTEGER;

DBMS_LOB.GETLENGTH (
lob_loc IN CLOB CHARACTER SET ANY_CS)
RETURN INTEGER;

DBMS_LOB.GETLENGTH (
file_loc IN BFILE)
RETURN INTEGER;

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus