Triggers and Window Service

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.
 >> Stay informed about: Triggers and Window Service 

Well, the information needed for the external vendors can be selected
by SQL but the information is presented for the vendors in a variety of
ways (tagged flat file, XML and in a view) I am limited by the vendor
as to the method of presenting the information. The view is simple.
It is the creating of the tagged files that have my concern. FTP or
mail is not an option. Any other suggestions?

Thanks
LuAnn
 >> Stay informed about: Triggers and Window Service 

LuAnn (bearpackexpress@hotmail.com) wrote:
: Well, the information needed for the external vendors can be selected
: by SQL but the information is presented for the vendors in a variety of
: ways (tagged flat file, XML and in a view) I am limited by the vendor
: as to the method of presenting the information. The view is simple.
: It is the creating of the tagged files that have my concern. FTP or
: mail is not an option. Any other suggestions?

The database can write the data out in various ways. Though I have never
done this, I understand you can write a file into the server's file space
directly from sql running on the server.

So - your trigger outputs anything to the file system. The windows
service monitors the file system. A windows system function can wake your
windows service whenever a file appears in a directory. I don't know the
call to do that, but am pretty sure such a call exists.

When your service wakes then it looks up the data (or reads it from the
file itself if that makes sense) and does what it needs to do.



--

This space not for rent.
 >> Stay informed about: Triggers and Window Service 

"LuAnn" <bearpackexpress RemoveThis @hotmail.com> wrote in message
news:1109107224.509508.241380@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
<a style='text-decoration: underline;' href="http://www.niall.litchfield.dial.pipex.com" target="_blank">http://www.niall.litchfield.dial.pipex.com</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Triggers and Window Service 

"LuAnn" <bearpackexpress RemoveThis @hotmail.com> wrote in message
news:1109109501.884977.205020@g14g2000cwa.googlegroups.com...
 > Well, the information needed for the external vendors can be selected
 > by SQL but the information is presented for the vendors in a variety of
 > ways (tagged flat file, XML and in a view) I am limited by the vendor
 > as to the method of presenting the information. The view is simple.
 > It is the creating of the tagged files that have my concern. FTP or
 > mail is not an option. Any other suggestions?
 >
 > Thanks
 > LuAnn
 >

how are the datasets transported to or picked up by the vendor? files?

formatting should be no problem with a PL/SQL procedure, which can easily
output to a fie (UTL_FILE) or directly to the web (if you're using AS or
HTMLDB)

++mcs<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Triggers and Window Service 

LuAnn wrote:

 > FTP or mail is not an option. Any other suggestions?
 >
 > Thanks
 > LuAnn

This is not an appropriate response on your part if you are asking
others for help. Instead of telling us what isn't an option ... tell
us what is.

One simple solution is DBMS_PIPE and write whatever you want in C.

Personally I think you entire design doesn't make business sense.
It may be technically feasible but why any delay at all? Why not
real-time?
--
Daniel A. Morgan
University of Washington
damorgan RemoveThis @x.washington.edu
(replace 'x' with 'u' to respond)<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Triggers and Window Service