"LuAnn" <bearpackexpress_at_hotmail.com> wrote in message
news:1109107224.509508.241380_at_g14g2000cwa.googlegroups.com...
> Without going into too much detail, there is a data entry program that
> writes to the database. A service is running that fires every 4 mins
> to see if there are any unprocessed rows in its defined table. If
> there is, it handles the necessary data manipulation to send the
> information outside of the database to be pickup by our external
> vendors. As timing is critical for this process, I am trying to find
> out if a trigger can be written to fire the service. This will
> eliminate the up to 7 minute delay to send this information. Let me
> know if you need more detail.
If the data manipulation can be done in SQL and the data needs to be sent
via mail or ftp then yes it can be done. I believe that this probably
answers you in the level of detail you require given your expanded question.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Tue Feb 22 2005 - 15:44:26 CST
