Pre-Defined Errors in Oracle

	ZERO_DIVIDE
	NO_DATA_FOUND
	DUP_VAL_ON_INDEX
	TOO_MANY_ROWS
	VALUE_ERROR
	CASE_NOT_FOUND
	INVALID_CURSOR
	CURSOR_ALREADY_OPEN
	ROW_TYPE_MISMATCH
	OTHERS


    NO_DATA_FOUND       (ORA-01403) — When a SELECT…INTO clause does not return any row from a table.
    TOO_MANY_ROWS       (ORA-01422) — When you SELECT or fetch more than one row into a record or variable.
    ZERO_DIVIDE         (ORA-01476) — When you attempt to divide a number by zero.
    CURSOR_ALREADY_OPEN (ORA-06511) — You tried to open a cursor that is already open.
    INVALID_CURSOR      (ORA-01001) — Illegal cursor operation occurred. 
                                      You tried to reference a cursor that does not yet exist. 
                                      This may have happened because you’ve executed a FETCH cursor or 
                                      CLOSE cursor before Opening the cursor.

    INVALID_NUMBER      (ORA-01722) — You tried to execute an SQL statement that tried to 
                                      convert a string to a number, but it was unsuccessful.
    DUP_VAL_ON_INDEX    (ORA-00001) — Attempted to insert a duplicate value.
    LOGIN_DENIED        (ORA-01017) — You tried to log into Oracle with an invalid username/password combination.
    NOT_LOGGED_ON       (ORA-01012) — You tried to execute a call to Oracle before logging in.
    VALUE_ERROR         (ORA-06502) — You tried to perform an operation and there was an error on a conversion,                                              truncation, or invalid constraining of numeric or character data.