Re: Can't update record - dup_val_on_index

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 - 06:42:19 CST