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

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

ORA-01403 no data found What causes an ORA-01403 error? In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all … Read more

ORA-01410

ORA-01410 invalid ROWID What causes an ORA-01410 error? A ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings using only numbers and the characters A through F. … Read more

ORA-01422

ORA-01422 exact fetch returns more than requested number of rows What causes an ORA-01422 error? The number specified in exact fetch is less than the rows returned. How Xynomix can … Read more

ORA-01424

ORA-01424 missing or illegal character following the escape character What causes an ORA-01424 error? The character following the escape character in LIKE pattern is missing or not one of the … Read more

ORA-01425

ORA-01425 escape character must be character string of length 1 What causes an ORA-01425 error? Given escape character for LIKE is not a character string of length 1. How Xynomix … Read more

ORA-01858

ORA-01858 a non-numeric character was found where a numeric was expected What causes an ORA-01858 error? The input data to be converted using a date format model was incorrect. The … Read more

ORA-01861

ORA-01861 literal does not match format string What causes an ORA-01861 error? Literals in the input must be the same length as literals in the format string (with the exception … Read more