Error Messages Page 2 ORA-00913: too many values ORA-00917: missing comma ORA-00918: column ambiguously defined ORA-00926: missing VALUES keyword ORA-00933: SQL command not properly ended ORA-00936: missing expression ORA-00998: must name this expression with a column alias ORA-00999: invalid view name ORA-01001: invalid cursor ORA-01017 invalid username/password; logon denied ORA-01017: invalid username/password logon denied ORA-01031…(Continue Reading)
Author: Dev
PLS-00615: type mismatch found at between CASE operand and WHEN operands
PLS-00615: type mismatch found at between CASE operand and WHEN operands Oracle PL/SQL error message: PLS-00615: type mismatch found at ‘string’ between CASE operand and WHEN operands Cause: In a simple CASE statement or expression, the CASE operand and WHEN operands do not match in datatype, and it is unclear which implicit conversion is required…(Continue Reading)
PLS-00372: In a procedure, RETURN statement cannot contain an expression
PLS-00372: In a procedure, RETURN statement cannot contain an expression Oracle PL/SQL error message: PLS-00372: In a procedure, RETURN statement cannot contain an expression. Cause: In a procedure, a RETURN statement contains an expression, which is not allowed. Solution: Remove the expression from the RETURN statement, or redefine the procedure as a function. Example: DECLARE…(Continue Reading)
ORA-01735: invalid ALTER TABLE option
ORA-01735: invalid ALTER TABLE option Oracle PL/SQL error message: ORA-01735: invalid ALTER TABLE option. Cause: An invalid option was specified in an ALTER TABLE statement. Solution: Check the statement syntax, specify a valid option, and retry the statement. Example: ALTER TABLE test2 ADD test_id_pk PRIMARY KEY(test_id); Output: ORA-01735: invalid ALTER TABLE option Correct ALTER TABLE…(Continue Reading)
ORA-02431: cannot disable constraint
ORA-02431: cannot disable constraint Oracle PL/SQL error message: ORA-02431: cannot disable constraint. Cause: The named constraint does not exist for this table. Solution: Check that a constraint exists before trying to disable it. Example: ALTER TABLE test DISABLE CONSTRAINT constraint_name; Output: ORA-02431: cannot disable constraint Check constraint SELECT OWNER, CONSTRAINT_NAME, STATUS FROM user_constraints WHERE table_name…(Continue Reading)