D SQLSTATE Codes

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