17,086
社区成员
发帖
与我相关
我的任务
分享oraclE中读取clob时出错大家帮忙
c1.getSubString((long)1,c1.length());
报错类型长度大于最大值
我不清楚怎么回事，
大家帮忙看看
报错类型长度大于最大值
我不清楚怎么回事，
大家帮忙看看
...全文
请发表友善的回复…
发表回复
qquge 2004-06-16
- 打赏
- 举报
study
dkmilk 2004-03-24
- 打赏
- 举报
谢谢看了一下没看明白
谁解释一下。
谁解释一下。
beckhambobo 2004-03-23
- 打赏
- 举报
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;
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;
dkmilk 2004-03-23
- 打赏
- 举报
出现上面错误后
再执行SQL
就报错：违反协议
再执行SQL
就报错：违反协议
