Error Messages Page 2

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)

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)