반응형
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 |
'전산Tip > Oracle' 카테고리의 다른 글
[ORACLE] DROP TABLE시 휴지통 파일 생성하지 않기 (0) | 2010.05.17 |
---|---|
오라클 DIRECTORY 생성 명령어 (0) | 2010.04.30 |
오라클 유저 패스워드 변경 (0) | 2010.04.30 |