Category: PL/SQL

ORA-00905: missing keyword Oracle PL/SQL error message: ORA-00905: missing keyword. Cause: A required keyword is missing. Solution: Correct the syntax. Example: CREATE OR REPLACE VIEW VIEW_1 SELECT * FROM TEST3; Output: ORA-00905: missing keyword Correct: CREATE OR REPLACE VIEW VIEW_1 AS SELECT * FROM TEST3; Output: view VIEW_1 created.

ORA-00922: missing or invalid option Oracle PL/SQL error message: ORA-00922: missing or invalid option. Cause: An invalid option was specified in defining a column or storage clause. Solution: Correct the syntax. Example: CREATE TABLE TEST4 SELECT * FROM TEST3; Output: ORA-00922: missing or invalid option Correct: CREATE TABLE TEST4 AS SELECT * FROM TEST3; Output:…(Continue Reading)

ORA-00972: identifier is too long Oracle PL/SQL error message: ORA-00972: identifier is too long. Cause: You try to create an object name with more than 30 characters was specified. Solution: Specify at most 30 characters for the object name. Example: CREATE OR REPLACE VIEW AAAAA_BBBBB_CCCCC_DDDDD_12345678 AS SELECT * FROM TEST3; Output: ORA-00972: identifier is too…(Continue Reading)

ORA-02296: cannot enable – null values found Oracle PL/SQL error message: ORA-02296: cannot enable – null values found. Cause: You execute an ALTER TABLE statement with an ENABLE CONSTRAINT clause failed because the table contains NULL values. Solution: Set all NULL values in the column to values other than NULL, then re-execute the statement. Example:…(Continue Reading)

ORA-01449: column contains NULL values; cannot alter to NOT NULL Oracle PL/SQL error message: ORA-01449: column contains NULL values; cannot alter to NOT NULL. Cause: You execute an ALTER TABLE MODIFY statement attempted to change the definition of a column containing NULL values to NOT NULL. Solution: Set all NULL values in the column to…(Continue Reading)