Re: Can't update record - dup_val_on_index

Is there a database trigger which fires on update of the customer record and inserts a record elsewhere (possibly an audit-type trigger)?

"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 Wed Feb 23 2000 - 16:26:51 CET