email notification -- table record count -- Oracle 9i
Posted on 2012-04-04
We have an application that collects data from , say 50 input points and writes into a Oracle table. This means that every hour/ day at a given time 50 records are writtem into a table says AXIS. Is there a way a notification email be sent, if it misses any of these records?
Ex: today only 48 records got inserted , which means collection from 2 points is missing i.e 2 records.
In the past one of the experts assisted with this on a Oracle 11g database, now i need it on a Oracle 9i database.
I do not see the following in Oracle 9i..
also, i do not see SMTP_OUT_SERVER init parameter in 9i.
Please let me know what other information is required and i will try to provide it.
If there is a way to accomplish this in Oracle 9i, i would need someone to provide the solution.