请问一张表里面能有多少个CLOB子段

[mem_fox]

我在一张表里面设计了2个CLOB子段QUESTION和ANSWER,插入的代码是这样的
sql = "select question,answer from sample_clob where id=? FOR UPDATE" ;
statment = connection.prepareStatement(sql);
statment.setInt(1,id.intValue());
ResultSet res = statment.executeQuery();
if(res.next())
{
CLOB quest = ((OracleResultSet)res).getCLOB(1);
CLOB answ = ((OracleResultSet)res).getCLOB(2);
quest.putString(question.length(),question);
answ.putString(answ.length(),answer);
}
这样在插入的时候会说answ.putString调用了无效的参数,我把2个CLOB子段分开执行也不行.是不是之允许一个CLOB子段存在?
UPDATE的方法也是只能更新QUESTiON的内容,更新ANSWER虽然不出错,但是没有成功
sql = "update sample_clob set ANSWER=?,QUESTION=? where id=? " ;
statment = connection.prepareStatement(sql);
statment.setString(1,"Change answer");
statment.setString(2,"Change question");
statment.setInt(3,id.intValue());
statment.executeUpdate();
大家来帮帮忙

[conning333]

我记得是支持多个的

[lynx1111]

oracle 一张表可以有两个clob

http://www.csdn.net/develop/article/20/20484.shtm

[cbhyk]

跟具体的数据库有关

[lynx1111]

http://www.csdn.net/develop/article/20/20873.shtm

[JavaBoyCaoJi]

oracle 一张表可以有两个clob

[Wnyu]

up