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

Hi Bryan,
When I do that I get a couple of errors, one specifying owner.table.column and the second indicating the trigger failed, like this:

ORA-01400: cannot insert NULL into ("STEVE"."TESTNULL3"."COL3")
ORA-06512: at "STEVE.NULLFAIL", line 2
ORA-04088: error during execution of trigger 'STEVE.NULLFAIL'

If you could post your trigger code, I'll see if I can duplicate the problem you're having.

Hope this helps,
Steve

bryan munday wrote:

> 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.
> ------------------------------------------------------------
  Received on Thu Apr 12 2001 - 06:53:25 CDT