Re: Can't update record - dup_val_on_index

This is not happening.
[Quoted] Update commands do not insert new records. There is something else in your code that is doing the inserts.

--
Paul Dorsey
Dulcian, Inc.
(212) 595-7223
web address: http://www.dulcian.com
email: pdorsey_at_dulcian.com


[Quoted] Phoebe <phoebe_at_hkem.com> wrote in message
news:88or27$rcs$1_at_news.ctinets.com...


> 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

> > >

> > >

> > >

> > >

> > >

> > >

> > >

> > >

> > >

> >

> >

>

>