Programmer's Guide to SQL*Module for Ada
Release 8.0
A54660_01

Library

Product

Contents

Index


Prev Next

D
SQLSTATE Codes

This appendix contains a table of the SQLSTATE codes and the conditions and errors associated with them.

SQLSTATE Codes

Code  

Condition  

Oracle Error  

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  

 

SQLSTATE codes:




Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Contents

Index