RE: ORA-01400: cannot insert NULL into ()

From: bryan munday <bardy_at_MailAndNews.com>
Date: Thu, 12 Apr 2001 07:27:37 -0400
Message-ID: <3AE09A39@MailAndNews.com>

Please ignore this as I was being incredibly stupid (software had added not null columns to the table I had created and I forgot about them)

>===== Original Message From bryan munday <bardy_at_MailAndNews.com> =====
>Dear all,
>
>I have created a simple trigger to insert some data into a table when data
>is
>edited. The trigger compiles successfully however when I try and update teh
>relevant table, I get the 1400 error message. According to the manual I
>should get a listing of the owner table and trigger name instead of the ()
>in
>the message. Does anyone have any idea what is going wrong?
>
>I am using 8.0.5 on NT
>
>Thanks
>
>Bryan
>bardy00_at_hotmail.com
>
>The trigger is:
>create or replace trigger Inc_Date
>after UPDATE on bryan_trk.vct_errorstatus_update
>FOR EACH ROW
>WHEN (new.CTV_DSTATUS in ('CN','RM','RP'))
>BEGIN
> INSERT INTO query.inc_date_update
> (recid, pxlpid1a, discrep_status, inc_date, discrep_no,protocol)
> VALUES
>
>(:new.ctv_discr_recid,:new.pxlpid1a,:new.ctv_dstatus,:new.ctv_status_change_
>dt
>,:new.ctv_error_id,'BRYAN_TRK');
>END;
>/
>
>------------------------------------------------------------
> Get your FREE web-based e-mail and newsgroup access at:
> http://MailAndNews.com
>
> Create a new mailbox, or access your existing IMAP4 or
> POP3 mailbox from anywhere with just a web browser.
>------------------------------------------------------------

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Thu Apr 12 2001 - 06:27:37 CDT