Xynomix News

ORA-01036

ORA-01036 illegal variable name/number What causes an ORA-01036 error? Unable to find bind context on user side. How Xynomix can help Make sure that the variable being bound is in … Read more

ORA-01031

ORA-01031 insufficient privileges What causes an ORA-01031 error? An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to … Read more

ORA-01008

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

ORA-01002

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-01000

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-00999

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-00979

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-00975

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-00972

ORA-00972 identifier is too long What causes an ORA-00972 error? The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames. … Read more

ORA-22275

ORA-22275 invalid LOB locator specified What causes an ORA-22275 error? There are several causes: The LOB locator was never initialized The locator is for a BFILE and the routine expects … Read more