Author: Dev

ORA-01407: cannot update to NULL Oracle PL/SQL error message: ORA-01407: cannot update to NULL. Cause: You try to make an update in a NOT NULL column. Solution: Alter table column to nullable or update column with a value. Example: CREATE TABLE TEST (TEST_ID NUMBER NOT NULL, TEST_NAME VARCHAR2(5) NOT NULL ); Insert into TEST (TEST_ID,TEST_NAME)…(Continue Reading)

ORA-00957: duplicate column name Oracle PL/SQL error message: ORA-00957: duplicate column name. Cause: A column name was specified twice in a CREATE or INSERT statement. Column names must be unique within a table, view, or cluster. Solution: In a CREATE statement, change one of the column names to a new, unique column name. In an…(Continue Reading)

ORA-01418: specified index does not exist Oracle PL/SQL error message: ORA-01418: specified index does not exist. Cause: An ALTER INDEX, DROP INDEX, or VALIDATE INDEX statement specified the name of an index that does not exist. Only existing indexes can be altered, dropped, or validated. Existing indexes may be listed by querying the data dictionary.…(Continue Reading)

ORA-01408: such column list already indexed Oracle PL/SQL error message: ORA-01408: such column list already indexed. Cause: A CREATE INDEX statement specified a column that is already indexed. A single column may be indexed only once. Additional indexes may be created on the column if it is used as a portion of a concatenated index,…(Continue Reading)

ORA-00955: name is already used by an existing object Oracle PL/SQL error message: ORA-00955: name is already used by an existing object. Cause: An attempt was made to create a database object (table, view, cluster, index, or synonym) that already exists. Solution: Check the database object name and enter a unique name or modify or…(Continue Reading)