본문 바로가기

전산Tip/Oracle

ORACLE EXCEPTION NAME

반응형
http://psoug.org/reference/exception_handling.html


Predefined (Named) PL/SQL Exceptions
Exception Name Error Description
ACCESS_INTO_NULL ORA-06530 Attempted to assign values to the attributes of an uninitialized (NULL) object
CASE_NOT_FOUND ORA-06592 None of the choices in the WHEN clauses of a CASE statement is selected and there is no ELSE clause
COLLECTION_IS_NULL ORA-06531 Attempt to apply collection methods other than EXISTS to an uninitialized (NULL) PL/SQL table or varray
CURSOR_ALREADY_OPEN ORA-06511 Exactly what it seems to be. Tried to open a cursor that was already open
DUP_VAL_ON_INDEX ORA-00001 An attempt to insert or update a record in violation of a primary key or unique constraint
INVALID_CURSOR ORA-01001 The cursor is not open or not valid in the context in which it is being called
INVALID_NUMBER ORA-01722 It isn't a number even though you are treating it like one to trying to turn it into one
LOGIN_DENIED ORA-01017 Invalid name and/or password for the instance
NO_DATA_FOUND ORA-01403 The SELECT statement returned no rows or referenced a deleted element in a nested table or referenced an initialized element in an Index-By table
NOT_LOGGED_ON ORA-01012 Database connection lost
PROGRAM_ERROR ORA-06501 Internal PL/SQL error
ROWTYPE_MISMATCH ORA-06504 The rowtype does not match the values being fetched, or assigned, to it
SELF_IS_NULL ORA-30625 Program attempted to call a MEMBER method, but the instance of the object type has not been intialized. The built-in parameter SELF points to the object, and is always the first parameterpassed to a MEMBER method
STORAGE_ERROR ORA-06500 A hardware problem: Either RAM or disk drive
SUBSCRIPT_BEYOND_COUNT ORA-06533 Reference to a nested table or varray index higher than the number of elements in the collection
SUBSCRIPT_OUTSIDE_LIMIT ORA-06532 Reference to a nested table or varray index outside the declared range (such as -1)
SYS_INVALID_ROWID ORA-01410 The conversion of a character string into a universal rowid fails because the character string does not represent a valid rowid
TIMEOUT_ON_RESOURCE ORA-00051 The activity took too long and timed out
TOO_MANY_ROWS ORA-01422 The SQL INTO statement brought back more than one value or row (only one is allowed)
USERENV_COMMITSCN_ERROR ORA-01725 Added for USERENV enhancement, bug 1622213
VALUE_ERROR ORA-06502 An arithmetic, conversion, truncation, or size-constraint error. Usually raised by trying to cram a 6 character string into a VARCHAR2(5) variable
ZERO_DIVIDE ORA-01476 Not only would your math teacher not let you do it. Computer's won't either. Who said you didn't learn anything useful in primary school