ORA-01400: cannot insert NULL into : NOT NULL « Table « Oracle PL/SQL Tutorial. ('Kyta') * ERROR at line 1: ORA-01400: cannot insert NULL into ( JAVA2S. ORACLE - Cannot insert a NULL value to a NON-Primary Key. up vote 1 down vote favorite. SQL/Oracle - “Cannot insert null into primary key. ORA-01400: cannot insert NULL into. Oracle PL/SQL error message. name, dept_id, salary) VALUES (1, NULL, 20, 250); SQL Error: ORA-01400: cannot insert NULL into. Oracle - Error: 'ORA-01400: cannot insert NULL into. up vote 2 down vote favorite. JPA inserts and the dreaded ORA-01400: cannot insert NULL into tablename exception. For example, it could be a literal, a PL/SQL. forms of INSERT statement: INSERT INTO. SECURITY GUARD', 2045, NULL, 30);. INSERT INTO. ORA-01400: cannot insert NULL Oracle tips by Burleson. SQL desc invoice. Another solution for the ORA-01400 error is to modify the table to make the column. Oracle PL/SQL to Excel XSLX API The most powerful PL/SQL Excel API in the World. Dude, if it says cannot insert NULL, trust it! You must be trying to insert (or update) a null value on a not null column. All Places Database Database Application Development PL/SQL and SQL Discussions This. ORA-01400: cannot insert NULL into create table sara1 (ID number. Fundamentals of PL/SQL. wages 2000 THEN INSERT INTO temp VALUES (NULL. simple CASE statement or CASE expression yields NULL, it cannot be matched by using.