Author: Dev

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)

The Oracle PL/SQL error message ORA-01858 occurs when a non-numeric character is encountered in a context where a numeric value is expected. This error is related to date and time operations in Oracle Database. The most common scenario is when attempting to perform date or timestamp arithmetic, comparisons, or conversions, and Oracle encounters a character…(Continue Reading)