Skip to content

All Oracle errors

Every error in the library, by number and alphabetically. 50 errors so far.

By error code

  1. ORA-00001 unique constraint violated
  2. ORA-01400 cannot insert NULL into
  3. ORA-02291 integrity constraint violated - parent key not found
  4. ORA-02292 integrity constraint violated - child record found
  5. ORA-00907 missing right parenthesis
  6. ORA-00911 invalid character
  7. ORA-00933 SQL command not properly ended
  8. ORA-00936 missing expression
  9. ORA-00937 not a single-group group function
  10. ORA-00979 not a GROUP BY expression
  11. ORA-01427 single-row subquery returns more than one row
  12. ORA-00942 table or view does not exist
  13. ORA-00904 invalid identifier
  14. ORA-00918 column ambiguously defined
  15. ORA-00955 name is already used by an existing object
  16. ORA-01722 invalid number
  17. ORA-12899 value too large for column
  18. ORA-00932 inconsistent datatypes
  19. ORA-01843 not a valid month
  20. ORA-01861 literal does not match format string
  21. ORA-01438 value larger than specified precision allowed for this column
  22. ORA-06502 PL/SQL: value or conversion error
  23. ORA-06512 at line (PL/SQL error stack)
  24. ORA-01403 no data found
  25. ORA-01422 exact fetch returned more than the requested number of rows
  26. ORA-01008 value for bind variable placeholder was not provided
  27. ORA-06550 line, column: (PL/SQL compilation error)
  28. ORA-04091 table is mutating, trigger/function may not see it
  29. ORA-20000 user-defined error (RAISE_APPLICATION_ERROR, ORA-20000 to ORA-20999)
  30. PLS-00201 identifier must be declared
  31. PLS-00103 Encountered the symbol ... when expecting one of the following
  32. PLS-00306 wrong number or types of arguments in call
  33. ORA-00060 deadlock detected while waiting for resource
  34. ORA-00054 resource busy (failed to acquire a lock held by another session)
  35. ORA-01555 snapshot too old
  36. ORA-01017 invalid credential or not authorized; logon denied
  37. ORA-28000 The account is locked; login denied.
  38. ORA-28001 The account has expired. The password must be changed.
  39. ORA-01031 insufficient privileges
  40. ORA-65096 common user or role name must start with prefix C##
  41. ORA-01652 unable to extend temp segment
  42. ORA-01653 unable to extend table
  43. ORA-01000 maximum open cursors exceeded
  44. ORA-01034 The Oracle instance is not available for use (ORACLE not available)
  45. ORA-12154 cannot find alias (could not resolve the connect identifier)
  46. ORA-12514 service is not registered with the listener
  47. ORA-12541 no listener at the host and port
  48. ORA-12170 connect timeout occurred
  49. ORA-12560 database communication protocol error (TNS:protocol adapter error)
  50. ORA-03113 end-of-file on communication channel

A to Z by message

A

C

D

E

I

L

M

N

P

R

S

T

U

V

W