Re: Can't update record - dup_val_on_index

The customer table only have a primary key on ID. But when i drop the primary key, I can update the record successfully. However it will also insert one more same record into the table. Can anyone tell me how can i update the record without insert one more same record??
Thanks in advance.

Phoebe

Paul Dorsey <pdorsey_at_dulcian.com> wrote in message news:LiRr4.15115$pN1.219098_at_news1.rdc1.nj.home.com...
> Look at what indexes are on the table.
> You probably have a unique index on name.
>
> --
> Paul Dorsey
> Dulcian, Inc.
> (212) 595-7223
> web address: http://www.dulcian.com
> email: pdorsey_at_dulcian.com
>
>
> Phoebe <phoebe_at_hkem.com> wrote in message
> news:88oec7$nm8$1_at_news.ctinets.com...
> > Dear all,
> >
> > I am writing application to update the record. I try to update the
> > record when the "save" button pressed. But it throws an exception :
> > dup_val_on_index
> >
> > cursor cur_cus is select * from customer
> > where :id = id
> > for update nowait;
> > val_cus cur_cus%rowtype;
> >
> > if cur_cus%found then
> > update customer set name = :name,
> > address = :address
> > where id = :id;
> > commit;
> >
> > Can anyone tell me why dup_val_on_index raised when i update the record
??
> > Thanks in advance.
> >
> > Phoebe
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
Received on Sun Feb 20 2000 - 07:51:29 CST