00000 |
successful completion |
ORA-00000 |
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 |
ORA-01095
ORA-01403 |
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 |
SQL-02126 |
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 |
SQL-02121 |
08004 |
SQL server rejected SQL connection |
|
08006 |
connection failure |
|
08007 |
transaction resolution unknown |
|
0A000 |
feature not supported |
ORA-03000 .. 03099 |
0A001 |
multiple server transactions |
|
21000 |
cardinality violation |
ORA-01427
SQL-02112 |
22000 |
data exception |
|
22001 |
string data - right truncation |
ORA-01401
ORA-01406 |
22002 |
null value - no indicator parameter |
ORA-01405
SQL-02124 |
22003 |
numeric value out of range |
ORA-01426
ORA-01438
ORA-01455
ORA-01457 |
22005 |
error in assignment |
|
22007 |
invalid date-time format |
|
22008 |
date-time field overflow |
ORA-01800 .. 01899 |
22009 |
invalid time zone displacement value |
|
22011 |
substring error |
|
22012 |
division by zero |
ORA-01476 |
22015 |
interval field overflow |
|
22018 |
invalid character value for cast |
|
22019 |
invalid escape character |
ORA-00911
ORA-01425 |
22021 |
character not in repertoire |
|
22022 |
indicator overflow |
ORA-01411 |
22023 |
invalid parameter value |
ORA-01025
ORA-01488
ORA-04000 .. 04019 |
22024 |
unterminated C string |
ORA-01479 .. 01480 |
22025 |
invalid escape sequence |
ORA-01424 |
22026 |
string data - length mismatch |
|
22027 |
trim error |
|
23000 |
integrity constraint violation |
ORA-00001
ORA-02290 .. 02299 |
24000 |
invalid cursor state |
ORA-01001 .. 01003
ORA-01410
ORA-08006
SQL-02114
SQL-02117
SQL-02118
SQL-02122 |
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 |
ORA-02091 .. 02092 |
40001 |
serialization failure |
|
40002 |
integrity constraint violation |
|
40003 |
statement completion unknown |
|
42000 |
syntax error or access rule violation |
ORA-00022
ORA-00251
ORA-00900 .. 00999
ORA-01031
ORA-01490 .. 01493
ORA-01700 .. 01799
ORA-01900 .. 02099
ORA-02140 .. 02289
ORA-02420 .. 02424
ORA-02450 .. 02499
ORA-03276 .. 03299
ORA-04040 .. 04059
ORA-04070 .. 04099 |
44000 |
with check option violation |
ORA-01402 |
60000 |
system errors |
ORA-00370 .. 00429
ORA-00600 .. 00899
ORA-06430 .. 06449
ORA-07200 .. 07999
ORA-09700 .. 09999 |
61000 |
resource error |
ORA-00018 .. 00035
ORA-00050 .. 00068
ORA-02376 .. 02399
ORA-04020 .. 04039 |
62000 |
multi-threaded server and detached process errors |
ORA-00100 .. 00120
ORA-00440 .. 00569 |
63000 |
Oracle*XA and two-task interface errors |
ORA-00150 .. 00159
SQL-02128
ORA-02700 .. 02899
ORA-03100 .. 03199
ORA-06200 .. 06249 |
64000 |
control file, database file, and redo file errors;
archival and media recovery errors |
ORA-00200 .. 00369
ORA-01100 .. 01250 |
65000 |
PL/SQL errors |
ORA-06500 .. 06599 |
66000 |
SQL*Net driver errors |
ORA-06000 .. 06149
ORA-06250 .. 06429
ORA-06600 .. 06999
ORA-12100 .. 12299
ORA-12500 .. 12599 |
67000 |
licensing errors |
ORA-00430 .. 00439 |
69000 |
SQL*Connect errors |
ORA-00570 .. 00599
ORA-07000 .. 07199 |
72000 |
SQL execute phase errors |
ORA-01000 .. 01099
ORA-01400 .. 01489
ORA-01495 .. 01499
ORA-01500 .. 01699
ORA-02400 .. 02419
ORA-02425 .. 02449
ORA-04060 .. 04069
ORA-08000 .. 08190
ORA-12000 .. 12019
ORA-12300 .. 12499
ORA-12700 .. 21999 |
82100 |
out of memory (could not allocate) |
SQL-02100 |
82101 |
inconsistent cursor cache: unit cursor/global cursor mismatch |
SQL-02101 |
82102 |
inconsistent cursor cache: no global cursor entry |
SQL-02102 |
82103 |
inconsistent cursor cache: out of range cursor cache reference |
SQL-02103 |
82104 |
inconsistent host cache: no cursor cache available |
SQL-02104 |
82105 |
inconsistent cursor cache: global cursor not found |
SQL-02105 |
82106 |
inconsistent cursor cache: invalid Oracle cursor number |
SQL-02106 |
82107 |
program too old for runtime library |
SQL-02107 |
82108 |
invalid descriptor passed to runtime library |
SQL-02108 |
82109 |
inconsistent host cache: host reference is out of range |
SQL-02109 |
82110 |
inconsistent host cache: invalid host cache entry type |
SQL-02110 |
82111 |
heap consistency error |
SQL-02111 |
82112 |
unable to open message file |
SQL-02113 |
82113 |
code generation internal consistency failed |
SQL-02115 |
82114 |
reentrant code generator gave invalid context |
SQL-02116 |
82115 |
invalid hstdef argument |
SQL-02119 |
82116 |
first and second arguments to sqlrcn both null |
SQL-02120 |
82117 |
invalid OPEN or PREPARE for this connection |
SQL-02122 |
82118 |
application context not found |
SQL-02123 |
82119 |
connect error; can't get error text |
SQL-02125 |
82120 |
precompiler/SQLLIB version mismatch. |
SQL-02127 |
82121 |
FETCHed number of bytes is odd |
SQL-02129 |
82122 |
EXEC TOOLS interface is not available |
SQL-02130 |
90000 |
debug events |
ORA-10000 .. 10999 |
99999 |
catch all |
all others |
HZ000 |
remote database access |
|