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-01756 quoted string not properly terminated What causes an ORA-01756 error? A quoted string must be terminated with a single quote mark (‘). How Xynomix can help Insert the closing … Read more
ORA-04043 object string does not exist What causes an ORA-04043 error? An object name was specified that was not recognized by the system. Following are possible causes: An invalid name … Read more
ORA-04063 string has errors What causes an ORA-04063 error? Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax … Read more
ORA-06550 line string, column string:string What causes an ORA-06550 error? A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block … Read more
