Re: Oracle error 01400
Date: Thu, 26 Jul 2001 16:46:03 -0400
Message-ID: <vg%77.21226$A4.2238226_at_news20.bellglobal.com>
Did you check if there is a trigger on the table. BEFORE INSERT TRIGGER.
"Omar Malik" <obNOSPAMmar_at_hotmail.com> wrote in message
news:9jpg8o0ar7_at_enews4.newsguy.com...
> Hello
> I am stuck with a problem which doesn't seem to have a solution. I am
> trying to insert data into a table of jobs and trying to produce an
indexed
> number for the new job. The column job_id has constraint (primary) and
> therefore it should produce an indexed (new and unique)job_id when I try
to
> add a new job. But I keep getting the error 'can't insert null value into
> coloumn job_id'. I tried to change the constraint for the column to
unique
> but all that does is creates a table entry with a null job_id. Please
help
> me solve this problem. Thanks
>
>
Received on Thu Jul 26 2001 - 22:46:03 CEST