ORA-00926 missing VALUES keyword What causes an ORA-00926 error? An INSERT statement has been entered without the keyword VALUES or SELECT. Either a VALUES clause or a SELECT subquery must … Read more


ORA-00927 missing equal sign What causes an ORA-00927 error? An equal sign has been omitted in one of the following places: Cause:  In the SET clause of an UPDATE statementFollowing … Read more


ORA-00928 missing SELECT keyword What causes an ORA-00928 error? A SELECT subquery must be included in a CREATE VIEW statement. How Xynomix can help Correct the syntax. Insert the required … Read more


ORA-01400 cannot insert NULL into (string) What causes an ORA-01400 error? An attempt was made to insert a NULL into the column “USER”.”TABLE”.”COLUMN”. For example, if you enter: connect scott/tiger … Read more


ORA-01427 single-row subquery returns more than one row What causes an ORA-01427 error? The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify … Read more


ORA-01455 converting column overflows integer datatype What causes an ORA-01455 error? The converted form of the specified expression was too large for the specified datatype. How Xynomix can help Define … Read more


ORA-08006 specified row no longer exists What causes an ORA-08006 error? The row has been deleted by another user since the operation began. How Xynomix can help Retry the operation. … Read more


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


ORA-01488 invalid nibble or byte in the input data What causes an ORA-01488 error? A conversion request cannot be performed because a digit was invalid. How Xynomix can help Fix … Read more


ORA-01722 invalid number What causes an ORA-01722 error? The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only … Read more