| problem to delete record [message #513382] |
Mon, 27 June 2011 03:20  |
narang79
Messages: 137
Registered: June 2010
|
Senior Member |
|
|
i m using oracle 10g forms
in one form
there are multiple records shown in this form
i m using one delete button
coding is
declare
v_yes_no varchar2(1);
begin
v_yes_no:=display_alert2('alert_2','Caution','Do you want to delete current record');
if v_yes_no='Y' then
GO_BLOCK('IMPROVEMENT_SUGGESTION');
DELETE_RECORD;
end if;
end;
but when i press this button then one message shown on secreen
you can not delete this record
when i debug the form
message shown through on error trigger
i can not understand why this message ocuured
and record not deleted
no any constraint use in this form
but if i delete record from backend then records
delete successfully
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
