Common Oracle Errors

Abnormal	Oracle Error number	Sqlcode value	Throw the opportunity
Access_into_null	ORA-06530	-6530	The program attempts to assign a value to an uninitialized (automatically assigned null) object's properties.
Case_not_found	ORA-06592	-6592	No when clause in the case statement satisfies the condition, and the ELSE clause is not written.
Collection_is_null	ORA-06531	-6531	The program attempts to invoke a collection method (excluding exists) that is not initialized (automatically assigned to null) to a nested table or variable-length array, or if the program attempts to assign a value to an element that has not initialized a nested table or variable-length array.
Cursor_already_open	ORA-06511	-6511	The program tries to open a cursor that is already open. A cursor must be closed before it is reopened. A cursor for loop automatically opens the cursor it references. Therefore, our program cannot open the cursor inside the loop.
Dup_val_on_index	ORA-00001	-1	The program tries to save duplicate values to a database field that has a unique constraint.
Invalid_cursor	ORA-01001	-1001	The program attempts to manipulate an illegal cursor, such as closing an open cursor.
Invalid_number	ORA-01722	-1722	In an SQL statement, an error occurs when a string is converted to a number because the string does not represent a valid number. (in a procedural statement, an exception value_error is thrown.) This exception is also thrown when the limit clause expression of a FETCH statement is not followed by a positive number.
Login_denied	ORA-01017	-1017	The program attempts to log on to Oracle using an invalid user name and/or password.
No_data_found	ORA-01403	100	The SELECT into statement does not return data, or our program references a deleted element in a nested table or an uninitialized element in the index table. SQL aggregate functions, such as AVG and SUM, can always return a value or null. Therefore, a SELECT INTO statement that calls an aggregate function never throws an No_data_found exception. The FETCH statement will eventually not fetch the data, and when this happens, there will be no exception thrown.
not_logged_on	ORA-01012	-1012	The program does not connect to Oracle to invoke the database.
Program_error	ORA-06501	-6501	The PL/SQL program has an internal error.
Rowtype_mismatch	ORA-06504	-6504	The primary cursor variable used in the assignment statement is incompatible with the type of the PL/SQL cursor variable. For example, when an open primary cursor variable is passed to a stored subroutine, the return type and parameters of the argument must be the same.
Self_is_null	ORA-30625	-30625	The program tries to invoke an empty instance of the member method. That is, the built-in parameter, self (which is always the first parameter passed to the member method) is empty.
Storage_Error	ORA-06500	-6500	PL/SQL run-time memory overflow or low memory.
Subscript_beyond_count	ORA-06533	-6533	The program references a nested table or variable-length array element, but uses a subscript index that exceeds the total number of nested tables or variable-length array elements.
Subscript_outside_limit	ORA-06532	-6532	The program references a nested table or variable-length array, but the subscript index used is not in the legal range (for example,-1).
Sys_invalid_rowid	ORA-01410	-1410	An error occurred converting from string to rowID because the string does not represent a valid ROWID.
Timeout_on_resource	ORA-00051	-51	A time-out occurs when Oracle waits for resources.
Too_many_rows	ORA-01422	-1422	The SELECT into statement returns multiple rows of data.
Value_error	ORA-06502	-6502	An arithmetic, conversion, intercept, or length constraint error occurred. For example, when our program puts the value of a field in a character variable, if the value is longer than the length of the variable, PL/SQL terminates the assignment and throws an exception value_error. In a procedural statement, if a string fails to convert to a number, the exception value_error is thrown. (In SQL statements, exception Invalid_number are thrown.) )
Zero_divide	ORA-01476	-1476	Program

Common Oracle Errors