OraFAQ Forum: Forms » attaching triggers to form

Home » Developer & Programmer » Forms » attaching triggers to form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

attaching triggers to form [message #144633]

Thu, 27 October 2005 08:43

Sharaf
Messages: 62
Registered: September 2005
Location: U.K

Member

i have a trigger working fine in my database environment i need to activate the same in my form. An example is as below

create or replace trigger who_can__err_trig
Before insert on applicant
For each row
Declare
Begin
if
( add_months(:new.dob,12*16) >= trunc(sysdate) )
OR
:new.ELIGIBILITY = 'No'
OR
:new.ANTI_SOCIAL_BEH = 'Yes'
THEN
Raise_application_error(-20100,'Applicant not allowed');
end if;
end who_can__err_trig;
/
I have the above working fine in sql*plus how will i attach it to my form

Report message to a moderator