Can't update record - dup_val_on_index
From: Phoebe <phoebe_at_hkem.com>
Date: Sun, 20 Feb 2000 18:14:55 +0800
Message-ID: <88oec7$nm8$1_at_news.ctinets.com>
[Quoted] Dear all,
Date: Sun, 20 Feb 2000 18:14:55 +0800
Message-ID: <88oec7$nm8$1_at_news.ctinets.com>
[Quoted] Dear all,
[Quoted] 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 ?? [Quoted] Thanks in advance.
Phoebe Received on Sun Feb 20 2000 - 11:14:55 CET