SQL*Module for Ada Programmer's Guide
Release 8.0

A58231-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

 

 




Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index