• 全部
  • Oracle 基础和管理
  • Oracle 高级技术
  • Oracle 认证与考试
  • 职位交流
  • 问答

"Ora-22990: Lob 定位器无法扩展展事物处理" 是什么错误,如何解决?

wt_sanlian 2003-11-14 01:27:07

Please help!
...全文
154 点赞 收藏 3
写回复
3 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
wt_sanlian 2004-01-04
谢谢
回复
xzou 2003-11-14
ORA-22990 LOB locators cannot span transactions
Cause: A LOB locator selected in one transaction cannot be used in a different transaction.
Action: Reselect the LOB locator and retry the operation.
意思是说在一个transaction查询使用的lob定位不能在另一个transaction里面使用,要在新的transaction使用的话要重新打开,重新定位
回复
hdkkk 2003-11-14
Problem Explanation: ==================== The above sql statements were executed within a for loop. After each fetch a call to dbms_lob.copy is made followed by commit within the loop. Fetching accross commits is not allowed since it results to cursor invalidation because the a COMMIT release any locks held by the session. From Oracle 8 Server Application Developer's Guide, Chapter 6, Large Objects: The insert statement automatically starts a transaction and locks the row. Once it has occurred, the locator may not be used outside the current transaction, since a COMMIT release any locks. Therefore any fetch after the lock will result in ORA-22990: LOB locators cannot span transactions. Problem References: =================== Oracle 8 Server Application Developer's Guide Search Words: ============= ORA-22990: lob locator cannot span transaction Solution: ========= It is not advisable to use a COMMIT inside a loop. Use commit after the loop ends.
.
回复
相关推荐
发帖
Oracle
创建于2007-09-28

1.6w+

社区成员

Oracle开发相关技术讨论
申请成为版主
帖子事件
创建了帖子
2003-11-14 01:27
社区公告
暂无公告