Author: Dev

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

ORA-02430: cannot enable constraint Oracle PL/SQL error message: ORA-02430: cannot enable constraint. Cause: The named constraint does not exist for this table. Solution: Check that a constraint exists before trying to enable it. Example: ALTER TABLE test ENABLE CONSTRAINT constraint_name; Output: ORA-02430: cannot enable constraint Check constraint SELECT OWNER, CONSTRAINT_NAME, STATUS FROM user_constraints WHERE table_name…(Continue Reading)