SQL返回码判别

连线北海
连线北海
连线北海
201
文章
6
评论
2017年12月23日23:41:16 评论 606 3602字阅读12分0秒

Code Condition

00000 successful completion
01000 warning
01001 cursor operation conflict
01002 disconnect error
01003 null value eliminated in set function
01004 string data - right truncation
01005 insufficient item descriptor areas
01006 privilege not revoked
01007 privilege not granted
01008 implicit zero-bit padding
01009 search condition too long for info schema
0100A query expression too long for info schema
02000 no data
07000 dynamic SQL error
07001 using clause does not match parameter specs
07002 using clause does not match target specs
07003 cursor specification cannot be executed
07004 using clause required for dynamic parameters
07005 prepared statement not a cursor specification
07006 restricted datatype attribute violation
07007 using clause required for result fields
07008 invalid descriptor count
07009 invalid descriptor index
08000 connection exception
08001 SQL client unable to establish SQL connection
08002 connection name in use
08003 connection does not exist
08004 SQL server rejected SQL connection
08006 connection failure
08007 transaction resolution unknown
0A000 feature not supported
0A001 multiple server transactions
21000 cardinality violation
22000 data exception
22001 string data - right truncation
22002 null value - no indicator parameter
22003 numeric value out of range
22005 error in assignment
22007 invalid date-time format
22008 date-time field overflow
22009 invalid time zone displacement value
22011 substring error
22012 division by zero
22015 interval field overflow
22018 invalid character value for cast
22019 invalid escape character
22021 character not in repertoire
22022 indicator overflow
22023 invalid parameter value
22024 unterminated C string
22025 invalid escape sequence
22026 string data - length mismatch
22027 trim error
23000 integrity constraint violation
24000 invalid cursor state
25000 invalid transaction state
26000 invalid SQL statement name
27000 triggered data change violation
28000 invalid authorization specification
2A000 direct SQL syntax error or access rule violation
2B000 dependent privilege descriptors still exist
2C000 invalid character set name
2D000 invalid transaction termination
2E000 invalid connection name
33000 invalid SQL descriptor name
34000 invalid cursor name
35000 invalid condition number
37000 dynamic SQL syntax error or access rule violation
3C000 ambiguous cursor name
3D000 invalid catalog name
3F000 invalid schema name
40000 transaction rollback
40001 serialization failure
40002 integrity constraint violation
40003 statement completion unknown
42000 syntax error or access rule violation
44000 with check option violation
60000 system errors
61000 resource error
62000 multi-threaded server and detached process errors
63000 Oracle*XA and two-task interface errors
64000 control file, database file, and redo file errors;
archival and media recovery errors
65000 PL/SQL errors
66000 SQL*Net driver errors
67000 licensing errors
69000 SQL*Connect errors
72000 SQL execute phase errors
82100 out of memory (could not allocate)
82101 inconsistent cursor cache: unit cursor/global cursor mismatch
82102 inconsistent cursor cache: no global cursor entry
82103 inconsistent cursor cache: out of range cursor cache reference
82104 inconsistent host cache: no cursor cache available
82105 inconsistent cursor cache: global cursor not found
82106 inconsistent cursor cache: invalid Oracle cursor number
82107 program too old for runtime library
82108 invalid descriptor passed to runtime library
82109 inconsistent host cache: host reference is out of range
82110 inconsistent host cache: invalid host cache entry type
82111 heap consistency error
82112 unable to open message file
82113 code generation internal consistency failed
82114 reentrant code generator gave invalid context
82115 invalid hstdef argument
82116 first and second arguments to sqlrcn both null
82117 invalid OPEN or PREPARE for this connection
82118 application context not found
82119 connect error; can't get error text
82120 precompiler/SQLLIB version mismatch.
82121 FETCHed number of bytes is odd
82122 EXEC TOOLS interface is not available
90000 debug events
99999 catch all
HZ000 remote database access

继续阅读
weinxin
微信公众号
分享IT信息技术、北海生活的网站。提供北海本地化的信息技术服务。
连线北海
  • 本文由 发表于 2017年12月23日23:41:16
  • 除非特殊声明,本站文章均为原创,转载请务必保留本文链接
关于EL表达式与thymeleaf 信息技术

关于EL表达式与thymeleaf

前言 很久之前,也许你在JSP代码中会遇到类似${person.name}、${person}这样的代码,这样的代码被称之为EL表达式,看起来像不像现在普遍使用的模板引擎thymeleaf里的用法? ...
Windows 10无法删除恢复分区 信息技术

Windows 10无法删除恢复分区

1  前言 Windows 10安装的时候,默认会创建一些类似【恢复】、【系统保留】分区,强迫症促使我想去删除它们,一般情况,通过【计算机管理】中的【磁盘管理】可以操作,但是你会发现根本没有删除选项,...
Tomcat增加管理账户 信息技术

Tomcat增加管理账户

默认情况下,Tomcat的管理功能是关闭的,如何开启? 使用文本编辑工具打开 ${TOMCAT_HOME}\conf\tomcat-users.xml 文件,在最下面可以看到Tomcat默认把用户以及...
匿名

发表评论

匿名网友 填写信息

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: