ORA Errors Codes

ORA-01435 user does not exist What causes an ORA-01435 error? This message is caused by any reference to a non-existent user. For example, it occurs if a SELECT, GRANT, or … Read more

ORA-00975 date + date not allowed What causes an ORA-00975 error? An attempt was made to add two date fields together. Dates may be added only to numeric fields, not … Read more

ORA-01438 value larger than specified precision allows for this column What causes an ORA-01438 error? When inserting or updating records, a numeric value was entered that exceeded the precision defined … Read more

ORA-00979 not a GROUP BY expression What causes an ORA-00979 error? The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not … Read more

ORA-00999 invalid view name What causes an ORA-00999 error? In a CREATE VIEW statement, the view name was missing or invalid. How Xynomix can help Enter a valid view name … Read more

ORA-01476 divisor is equal to zero What causes an ORA-01476 error? An expression attempted to divide by zero. How Xynomix can help Correct the expression, then retry the operation. Contact … Read more

ORA-01000 maximum open cursors exceeded What causes an ORA-01000 error? A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors … Read more

ORA-01002 fetch out of sequence Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This … Read more

ORA-01008 not all variables bound What causes an ORA-01008 error? A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value … Read more