OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » forms

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

forms [message #144976]

Sun, 30 October 2005 09:25

seyiisq
Messages: 125
Registered: September 2005

Senior Member

the post-insert trigger below on my applicant form gave compilation error

Declare
i_duration number;
i_dob date;
begin
select duration_live_mth, dob into i_duration, i_dob from applicant where applicant_id = :applicant.applicant_id;
if
( i_duration < 6)
or
((sysdate - i_dob) BETWEEN 16 AND 17) then
message ('APPLICATION SHOULD BE SUSPENDED RIGHT AWAY IN THE APPLICATION TABLE...');
end if;
end;

please advice

Report message to a moderator