form hangs
i upgraded our system from froms 11GR2 to forms 12.2.1.0 all the forms works except one form when a user updated a record the form hangs I found the cause of hanging a form the use of sysdate in the form please see the below if statements if :day_date>trunc(sysdate) and (:worked='Y' or nvl(:extra_days,0)>0 ) and dummy=0 then (hang the form) I replace it with the below statment if thr.check_date_ent(:day_date)=1 and (:worked='Y' or nvl(:extra_days,0)>0 ) and dummy=0 then (the form woks) the below function solve the problem create or replace function check_date_ent(pdate date) return number is |
Tagged:
0