Re: Unable to insert record in oracle form

From: Phoebe Ho <phoebe_at_hkem.com>
Date: Sat, 5 Feb 2000 12:23:21 +0800
Message-ID: <87g88s$jnm$1@news.ctinets.com>

I tried to truncate the table before insertion. But it fail again.

Phoebe

SKurosky <skurosky_at_aol.com> wrote in message news:20000204111230.24821.00001218_at_ng-ce1.aol.com...
> >Phoebe Wrote:
>
> > I am writing a program to insert record in form builder.
> > When i press "save" button and an error is raised.
> >
> > FRM-40508: oracle error : unable to insert record.
> > table : cus_id varchar2(10) primary key,
>
> Are you trying to insert a record with duplicate cust_id? That is what the
> "Primary Key" constraint is there to guard against. You should not have
> duplicate cust_id.
> Sandy
>
Received on Fri Feb 04 2000 - 22:23:21 CST