Re: Sequence problem

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/03/08
Message-ID: <19970308171801.MAA22306@ladder01.news.aol.com>#1/1

>>

SQL> insert into EAS_TYPE (EAS_TYPE,STATUS,REMARK,   2 ETYPE_KEY,
  3 ED_KEY,
  4 POST_DATE,USER_ID) values ( 'AV', 'ABX', NULL,   5 ETYPE_KEY.NextVal,
  6 970306135247 , sysdate, 'DPCAUH') ; ETYPE_KEY.NextVal,
*
ERROR at line 5:
ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert <<

The problem is not the sequence! The problem is that your insert fails to provide a value for a column in the table that always requires that a value exist for the column for every row in the table. Describe the table and compare it to your insert paying special attention to those columns label as 'not null'.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Sat Mar 08 1997 - 00:00:00 CST