Chapter 16: Using Stored Procedures
Reserved return status values
Adaptive Server reserves 0, to indicate a successful return,
and negative values from -1 through -99, to indicate the reasons
for failure. Numbers 0 and -1 through -14 are currently used in
versions 12 and later, as shown in Table 16-1:
Table 16-1: Reserved return status values
Value
|
Meaning
|
|---|
0
|
Procedure executed without error
|
-1
|
Missing object
|
-2
|
Datatype error
|
-3
|
Process was chosen as deadlock victim
|
-4
|
Permission error
|
-5
|
Syntax error
|
-6
|
Miscellaneous user error
|
-7
|
Resource error, such as out of space
|
-8
|
Nonfatal internal problem
|
-9
|
System limit was reached
|
-10
|
Fatal internal inconsistency
|
-11
|
Fatal internal inconsistency
|
-12
|
Table or index is corrupt
|
-13
|
Database is corrupt
|
-14
|
Hardware error
|
Values -15 through -99 are reserved for future use by Adaptive
Server.
If more than one error occurs during execution, the status
with the highest absolute value is returned.
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 