Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

frm-40735 when-button-pressed trigger raised unhandled exception ORA-01858

708498Oct 22 2009 — edited Oct 22 2009
hello to all,
i m making a form on which i placed a push button and write the following trigger when-button-pressed trigger :-
declare
d date:=to_date(sysdate,'yyyymm');
d1 varchar2(6):=to_char(d,'yyyymm');
cursor c is select * from prmamed where empno=00000127 and earningdeduction='E0010';
begin
set_application_property(cursor_style,'busy');
for rec in c loop
update prmamed
set paycalperiod=d1;
exit when c%notfound;
next_record;
end loop;
commit;
Message('updation done');
message(' ');
set_application_property(cursor_style,'default');
end;
but when i m pressing this push button then i m getting this error:-
frm-40735 when-button-pressed trigger raised unhandled exception ora-01858
plz help me out in removing this error
and could i use EXTRACT keywork to get the current year and month for the updation.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2009
Added on Oct 22 2009
5 comments
2,017 views