How do you trap default forms processing ( DML)

Interview Candidate
Aug 6th, 2005
4
8125

First
Prev
Next
Last

Showing Answers 1 - 4 of 4 Answers

ysumanth

Oct 27th, 2005

Override on- triggers
on insert /ondelete / on update

bc_sumanamara
Profile Answers by bc_sumanamara

Jan 12th, 2009

ON-DELETE IS USER TO TRAP DEFAULT DML
USED AT FORM LEVEL AND BLOCK LEVEL

EXAMPLE :

BEGIN
UPDATE emp
     SET termination_date = SYSDATE
   WHERE empno = :Emp.Empno;
IF form_fatal OR form_failure THEN
   raise form_trigger_failure;
END IF;
END;