Category: PL/SQL

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)

ORA-12899: value too large for column Oracle PL/SQL error message: ORA-12899: value too large for column. Cause: You tried to do an insert or an update column with a value too large for column. Solution: Enter a value smaller than the column width or expand the column width./p> Example: CREATE TABLE TEST( TEST_ID NUMBER NOT…(Continue Reading)

ORA-01400: cannot insert NULL into Oracle PL/SQL error message: ORA-01400: cannot insert NULL into. Cause: An attempt was made to insert a NULL into the column with not null constraint. Solution: Check and change your INSERT statement, replace the NULL with an value. Example: CREATE TABLE employees( id NUMBER NOT NULL, name VARCHAR2(250) NOT NULL,…(Continue Reading)

ORA-00947: not enough values Oracle PL/SQL error message: ORA-00947: not enough values. Cause: An INSERT statement with not enough values. Solution: Check and change your INSERT statement to avoid the duplicate values. Example: INSERT INTO employees(id, name, dept_id, salary) VALUES (‘Anne’, 20, 250); SQL Error: ORA-00947: not enough values Correct insert: INSERT INTO employees(id, name,…(Continue Reading)

ORA-00942: table or view does not exist Oracle PL/SQL error message: ORA-00942: table or view does not exist. Cause: The table or view entered does not exist. Solution: Check if you write the correct name of the table or view. Check if the table or view name exists in the database. Check if the user…(Continue Reading)