ORA-08002: sequence SEQ_TBL_ONLINE.CURRVAL is not yet defined in this session
来源:互联网 发布:linux链接网络 编辑:程序博客网 时间:2024/06/04 00:21
转载请注明来源-作者@loongshawn:http://blog.csdn.net/loongshawn/article/details/73917824,建议读者阅读原文,确保获得完整的信息
1.异常事例
登陆Navicat客户端,直接查看指定SEQ序列当前值:
SELECT SEQ_TBL_ONLINE.currval AS ID FROM dual
提示以下异常信息:
ORA-08002: sequence SEQ_TBL_ONLINE.CURRVAL is not yet defined in this session
2.异常分析
通过提示信息可知,其意思就是说当前会话没有定义SEQ_TBL_ONLINE.currval,换一个角度就是你需要新建一个这个序列的会话,通过下列方式创建:
SELECT SEQ_TBL_ONLINE.nextval AS ID FROM dual
即,先获取序列下一个值,取得这个会话,然后就可以通过currval获取当前值。
阅读全文
0 0
- ORA-08002: sequence SEQ_TBL_ONLINE.CURRVAL is not yet defined in this session
- Oracle/PLSQL ORA-08002: sequence NAME.CURRVAL is not yet defined in this session
- ORA-08002: sequence s%.CURRVAL is not yet defined in this session
- ORA-08002: sequence TEST1.CURRVAL is not yet defined in this session
- ORA-08002: sequence CURRVAL is not yet defined in this session
- ORA-08002: sequence SEQ_PREPAY.CURRVAL is not yet defined in this session的原因
- ORA-08002: sequence CURRVAL is not yet defined in this session
- currval of sequence "follow_id_seq" is not yet defined in this session
- google maps navigation is not yet available in this location
- Meteor Session is not defined解决办法
- An attempt was made to set a report parameter that is not defined in this report
- ORA-08002: SEQUENCES **.CURRVAL 未定义
- ORA-31623: a job is not attached to this session via the specified handle
- ORA-31623: a job is not attached to this session via the specified handle
- select sequence.currval 时报错 ORA-08002: 序列XXXX尚未在此进程中定义
- Why Docker is Not Yet Succeeding Widely in Production
- Shape Drawable----This is a generic shape defined in XML.
- IDEA 2017 use JAVA_HOME(not defined yet)
- 暑期项目开发实训 Day4
- opendaylight实现无线路由连接 -1
- 启动多个centos-ssh-http镜像容器
- 使用Java读取JSON数据
- 世纪佳缘信息爬取存储到mysql,下载图片到本地,从数据库选取账号对其发送消息更新发信状态
- ORA-08002: sequence SEQ_TBL_ONLINE.CURRVAL is not yet defined in this session
- # Exceptionin thread "main" java.lang.UnsatisfiedLinkError:org.apache.hadoop.util.NativeCrc32.native
- 软件
- 关于redis还有zookeeper
- C语言基础
- javascript的本地对象、内置对象、宿主对象
- Sicily 1119. Factstone Benchmark | 使用log函数缩小数值范围
- 九度OJ 1100:最短路
- JDK安装与配置