Re: Can't update record - dup_val_on_index

Look at what indexes are on the table.
[Quoted] 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

>

>

>

>

>

>

>

>

>