2 zcxgz362324 zcxgz362324 于 2016.02.16 17:31 提问

ORA-01002:fetch out sequence,提取顺序问题

现在的情况是第一次执行没有报错,第二次执行就报错:ORA-01002:fetch out sequence,
哪位大牛帮忙看看,我都看了一天了

3个回答

zcxgz362324
zcxgz362324   2016.02.17 18:56
已采纳

问题已经解决了,是因为数据库的存储过程执行错了,第一次没有删除成功

u014614478
u014614478   2016.02.16 17:38

看看你的序列生成是否有问题

zcxgz362324
zcxgz362324 这个应该不是序列问题,out of sequence--没有按照顺序的意思,和序列没有关系
2 年多之前 回复
Mr_dsw
Mr_dsw   Ds   Rxr 2016.02.16 20:49

你的操作顺序是否正确,别弄错了

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!
其他相关推荐
oracle ORA-01002: fetch out of sequence tips 违反提取顺序
The Oracle oerr utility  notes this on the ora-01002 error: ORA-01002: fetch out of sequence Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. N
ORA-01002 fetch out of sequence
 ORA-01002        fetch out of sequence Cause        In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This
主题:ORA-01002: fetch out of sequence问题
官方解释: ORA-01002: fetch out of sequence Cause: In a host language program, a FETCH call was issued out of seque
ORA-01002: fetch out of sequence
ORA-01002: fetch out of sequence 错误定位: SQL> !oerr ora 01002 01002, 00000, "fetch out of sequence" // *Cause: This error means that a fetch has been attempted from a cursor //         which is no
异常fetch out of sequence的生成原因
主要是因为使用ExpressDSO.save()(泛指一些需要事务控制,即可提交和回滚支持的方法)时没有将其作为事务提交,在spring.xml里经过以下配置后就可以了          class="com.ztesoft.ds.bizsvc.modify.AtomDealModifySvcImpl">                          class="org.springfram
oracle提示“ORA-01002: 提取违反顺序”
1、如果在遍历游标的时候 有insert的操作,并且执行了commit 那么,oracle会提示“ORA-01002: 提取违反顺序” 2、设置sql自动提交为false
ORA-01002 提取违反顺序
ORA-01002 提取违反顺序 ORA-01002 ORA-01002: fetch out of sequence Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly do
ORACLE存大文件出现 错误:读取违反顺序
 package common;import java.io.File;import java.io.FileInputStream;import java.io.OutputStream;import java.sql.Blob;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.Res
PL/SQL上报ORA-01002提取违反顺序
ORA-01002 ORA-01002: fetch out of sequence Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches
ORA-01002
Error Desc: fetch out of sequenceAction:1.Fetch action has been reached the last row.2.Lock on the tables are lost, many actions can cause this kind of errors, such as commit/rollback, ddl,etc ins