Category: PL/SQL

Error Messages ORA-00001: unique constraint violated ORA-00904: invalid identifier ORA-00905: missing keyword ORA-00908: missing NULL keyword ORA-00922: missing or invalid option ORA-00924: missing BY keyword ORA-00925: missing INTO keyword ORA-00934: group function is not allowed here ORA-00937: not a single-group group function ORA-00942: table or view does not exist ORA-00947: not enough values ORA-00955: name…(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 (such as a table, view, cluster, index, or synonym) that already exists. Solution: Enter a unique name for the database object or modify…(Continue Reading)

ORA-00904: invalid identifier Oracle PL/SQL error message: ORA-00904: invalid identifier. Cause: The column name entered is either missing or invalid. Solution: Check for correct column name. Enter a valid column name. Example: CREATE TABLE TEST2 (TEST_ID NUMBER NOT NULL ENABLE, TEST_NAME VARCHAR2(5) NOT NULL ENABLE ); INSERT INTO TEST2(TEST_ID, TEST_ABC) VALUES (2 ‘test’); Output: SQL…(Continue Reading)

ORA-01722: invalid number Oracle PL/SQL error message: ORA-01722: invalid number. Cause: You tried to insert a string to a numeric column or to assign a string to a numeric variable. Solution: Check and change the input you want to insert or assign. Example: CREATE TABLE TEST2 (TEST_ID NUMBER NOT NULL ENABLE, TEST_NAME VARCHAR2(5) NOT NULL…(Continue Reading)

ORA-06502: PL/SQL: numeric or value error: character to number conversion error Oracle PL/SQL error message: ORA-06502: PL/SQL: numeric or value error: character to number conversion error. Cause: You tried to do a numeric or string conversion or constraint error occurred. Solution: Change the data type with the same data type you declared. Example: declare v_id…(Continue Reading)