Common Oracle exception types

Common Oracle exception types: exception description CURSOR_ALREADY_OPEN tries to "OPEN" an opened cursor DUP_VAL_ON_INDEX tries to insert a duplicate value INVALID_CURSOR to "UNIQUE" and tries to operate on the closed cursor INVALID_NUMBER in the SQL statement to convert characters number failed LOGIN_DENIED use invalid user login NO_DATA_FOUND no data found when NOT_LOGIN_ON did not log on to Oracle when the command is issued PROGRAM_ERROR PL/SQL there are internal problems such as a function does not have a "RETURN" statement and other internal problems memory depletion or serious memory insufficiency TIMEOUT_ON_RESOURCE timeout occurred during Oracle wait for resources TOO_MANY_ROWS "select into" multi-row VALUE_ERROR returned when a value assignment error occurs ZERO_DIVIDE division zero