Some of the standard Oracle PLSQL Exception are as follow:
| 1 | NO_DATA_FOUND |
| 2 | TOO_MANY_ROWS |
| 3 | CURSOR_ALREADY_OPEN |
| 4 | DUP_VAL_ON_INDEX |
| 5 | INVALID_CURSOR |
| 6 | INVALID_NUMBER |
| 7 | ZERO_DIVIDE |
DUP_VAL_ON_INDEX - Attempted to insert a duplicate value
INVALID_CURSOR - Illegal cursor operation occurred
INVALID_NUMBER - Conversion of character string to number
fails
NO_DATA_FOUND - Single row SELECT returned no data
TOO_MANY_ROWS - Single-row SELECT returned more than one row
ZERO_DIVIDE - Attempted to divide by zero
No comments:
Post a Comment