Oracle Forms (MOSC)

MOSC Banner

form hangs

edited Nov 24, 2018 4:09AM in Oracle Forms (MOSC) 5 commentsAnswered
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center