In my Oracle forms program, when the user commits the form, the current values in the form are saved to the table. However, I also want to update a value in another record at the same time, i.e.
t_status_ind = 'I',
t_activity_date = sysdate
t_code = :t.t_code and t_seqno = :t.t_seqno-1
and t_status_ind = 'A';
I tried putting this code in the post_update trigger but nothing happens. When I put the code in the pre_save trigger I get the error: PRE_SAVE trigger raised unhandled exception ORA-20000. I do not know if I am going about it in the right away or putting the code in the correct location. I would greatly appreciate your help!