con.setAutoCommit(false);
//一句一句执行sql
DECLARE cont CLOB;
BEGIN
SELECT content INTO cont FROM clobt WHERE id=1 FOR UPDATE;
DBMS_LOB.WRITEAPPEND(cont, 5, 'abcde');
END;
////
con.commit();
con.setAutoCommit(true);
//一句一句执行sql
DECLARE cont CLOB;
BEGIN
SELECT content INTO cont FROM clobt WHERE id=1 FOR UPDATE;
DBMS_LOB.WRITEAPPEND(cont, 5, 'abcde');
END;
////
con.commit();
con.setAutoCommit(true);
解决方案 »
- 帮忙解决下SSH2整合时出现的问题
- 求高人指点诡异的java代码,包证很多人没见过。90%没用过
- 多家面试题求解!(java ee web开发)正在找工作的进来看看,求高手解答
- 急、、、、
- 敢问淘宝这是什么方式提交的了?
- ../help_b.jsp?session=460bf22eb38e 编码问题
- 问一下这个异常是什么问题
- 急啊,jspsmart上传图片到oracle,如果是在服务器本机操作上就可以保存图片到数据库,但是如果在别的机器上传就不行?????
- ResourceBundle类如何使用问题?
- 如何在用户关闭浏览器时执行自定义操作?
- 在servlet中有无jsp中类似“<jsp:setProperty name="a1" property="*" />”
- 请高手指教 session 是怎么使用的,我是初学的
//一句一句执行sql
DECLARE cont CLOB;
BEGIN
SELECT content INTO cont FROM clobt WHERE id=1 FOR UPDATE;
DBMS_LOB.WRITEAPPEND(cont, 5, 'abcde');
END;
////
con.commit();
con.setAutoCommit(true);
stmt.addBatch("DECLARE cont CLOB;");
stmt.addBatch("begin select content into cont from clobt where id=2 for update;");
stmt.addBatch("dbms_lob.writeappend(cont, 5, 'abcde');");
stmt.addBatch("END;");
stmt.executeBatch();
得到如下报错:
java.sql.BatchUpdateException: error occurred during batching: ORA-06550: line 1, column 18:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> cursor form currentat oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:380)
at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:432)
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4651)
at clobtest.clobMgr.addClob(clobMgr.java:314)
at clobtest.MainRun.main(MainRun.java:24)