Forum Stats

  • 3,838,655 Users
  • 2,262,389 Discussions
  • 7,900,724 Comments

Discussions

Problem while handling When-Validate-Record Trigger in Forms 6i

Wason Naveen
Wason Naveen Member Posts: 36
I am using below mention code in when validate trigger and use go block loop in when button pressed. if Check_Date_Range gives RAISE Form_Trigger_Failure error user will enter in a loop. kindly provide me solution for below mention problem.

BEGIN
Check_Date_Range(:Experiment.Start_Date,:Experiment.End_Date);
END;

/*
** The procedure looks like this
*/
PROCEDURE Check_Date_Range( d1 DATE, d2 DATE ) IS
BEGIN
IF d1 > d2 THEN
Message('Your date range ends before it starts!');
RAISE Form_Trigger_Failure;
END IF;
END;
Tagged:
This discussion has been closed.