[Err] ORA-02289: sequence does not exist序列不存在
来源:互联网 发布:行知小学 编辑:程序博客网 时间:2024/05/29 04:12
公司用的pgsql,获取序列时用的是 select nextval('seq_name'),放在引号里面,所以不会有大小写的问题。
晚上用Navicat创建序列时也给了小写的序列名,然后用 seq_name.nextval去获取序列时一直报ORA-02289: sequence does not exist的错误。
然后就发现oracle查询序列时大概是自动把序列名转成大写的,自然就提示找不到序列。改成大写的就好了。
ps:用pl/sql创建序列时会自动把小写的序列名转成大写,看来还是PL/SQL对oracle的支持比较好啊。
阅读全文
0 0
- [Err] ORA-02289: sequence does not exist序列不存在
- Hibernate: ORA-02289: sequence does not exist
- PAIP.HIBERNATE ORA-02289 sequence does not exist的解决
- java.sql.SQLException: ORA-02289: sequence does not exist
- 错误:java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist
- ORA-01720: grant option does not exist for 'xxx.xxxx' (ORA-01720 ‘XXX’ 不存在授权选项)
- ORA-29807: specified operator does not exist
- ORA-00959: tablespace 'PSAPTEMP' does not exist
- ORA-00959: tablespace '' does not exist
- ORA-01919: role 'PLUSTRACE' does not exist
- ORA-04043 object DROP_AW_ELIST_ALL does not exist
- ORA-02289: 序列不存在
- 【ORA】ORA-00030: User session ID does not exist.
- ORA-00942:table or view does not exist
- ORA-00942: table or view does not exist
- ORA-27101: shared memory realm does not exist 一种解决方案
- ORA-00942:table or view does not exist
- ORA-27101: shared memory realm does not exist
- Vue的Class 与 Style 绑定
- 时区修改
- Markdown编辑器用法
- 廖老师python教程实战Day5-编写web框架理解
- Java https访问
- [Err] ORA-02289: sequence does not exist序列不存在
- Android 7.1 GUI系统-窗口管理WMS-窗口大小计算(五)
- Linux 安装vsftpd
- django CKeditor 正常显示富文本
- Codeforces Round #451 (Div. 2) D. Alarm Clock
- Windows下使用Python配制环境以及打开方式
- 迷宫系列(三)利用BFS/DFS的数据得到最短路/通路
- 推荐系统经典论文文献及业界应用
- 门面模式