Oracle Alerts

Send alert via email/SMS with Oracle 9i & Oracle Forms 6i

Hi! I am using an application ,form6 as front end and oracle9i as back end. I want to sent alerts to the superiors as automail when certain data reaches the thresh hold and sent sms using certain service provider API ,to customer when certain condition is satisfied in the database. Kindly...