updating records ....

[deepaloshini]

how to update record in a database table from form builder if the datablock is a database block ?
one of the column is primary key ..
In Button-pressed trigger -

declare
empno number(6);
cur_empn number;
cursor c1 is select empn from srm;
begin
empno := :srm_block.empn;

open c1;
fetch c1 into cur_empn;
if empno = cur_empn then

update srm
set name = :srm_block.name
where empn = empno;

else
commit;
end if;
if c1%notfound then
proc_alert('DataNotFound');
end if;

close c1;

end;
This complete code is executing but the record is not getting updated ...
plz give me solution for this

[amitpatel66]

how to update record in a database table from form builder if the datablock is a database block ?
one of the column is primary key ..
In Button-pressed trigger -

declare
empno number(6);
cur_empn number;
cursor c1 is select empn from srm;
begin
empno := :srm_block.empn;

open c1;
fetch c1 into cur_empn;
if empno = cur_empn then

update srm
set name = :srm_block.name
where empn = empno;

else
commit;
end if;
if c1%notfound then
proc_alert('DataNotFound');
end if;

close c1;

end;
This complete code is executing but the record is not getting updated ...
plz give me solution for this

I think you have placed the COMMIT in the wrong place.

Place the COMMIT immediately after UPDATE statement in your code and then try executing the same.