| Author |
Message |
LuAnn
*nix forums beginner
Joined: 22 Feb 2005
Posts: 4
|
 Posted: Thu Feb 24, 2005 4:30 pm Post subject:
Re: Triggers and Window Service
|
|
|
I apolgize if I offended anyone and I am grateful to the suggestions.
I am (obviously) not familiar at all on what Oracle can assist with and
unfortunately I do not have a strong DBA to ask. Anyway enough
excuses. I have started to research all your suggestions. The service
was the initial method of choice because it could handle not only the
file creation but also disruption of the network and save these files
locally till the next firing. Yes unfortunately network disruption is
a very common happening here and we needed to program for it to
guarentee delivery. The file creation was mandatory by the vendors.
Their systems are on the WAN, but will not allow us to place anything
on their hardware and only one vendor had an import service that is
file driven. (so that is why no email) and FTP is locked down so tight
that we cannot even ftp within the same LAN. I understand that the
environment that I am creating in is not the norm, but it is all that
is available to me.
Again THANKS for the direction and the help...LuAnn |
|
| Back to top |
|
 |
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Wed Feb 23, 2005 10:18 am Post subject:
Re: Triggers and Window Service
|
|
|
LuAnn wrote:
| Quote: | 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
|
What doesn't make sense is that you are already in the database... why
go out to the OS ONLY to kick off another session to spool some data to
a file... which you could easily do from within the database as
mentioned by others. You are on version 9.x not 5.x and there are
couple of solid options that you can use... PL/SQL with UTL_FILE OR
PL/SQL with Java. (see dbms_xml% packages also).
Let the Database do what it does best and let the OS do what it does
best.
Regards
/Rauf |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Wed Feb 23, 2005 4:43 am Post subject:
Re: Triggers and Window Service
|
|
|
LuAnn wrote:
| Quote: | 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@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
Malcolm Dew-Jones
*nix forums Guru
Joined: 04 Mar 2005
Posts: 418
|
| Posted: Tue Feb 22, 2005 9:12 pm Post subject:
Re: 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. |
|
| Back to top |
|
|
Mark C. Stock
*nix forums Guru
Joined: 05 May 2005
Posts: 730
|
| Posted: Tue Feb 22, 2005 9:04 pm Post subject:
Re: Triggers and Window Service
|
|
|
"LuAnn" <bearpackexpress@hotmail.com> wrote in message
news:1109109501.884977.205020@g14g2000cwa.googlegroups.com...
| Quote: | 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 |
|
| Back to top |
|
|
LuAnn
*nix forums beginner
Joined: 22 Feb 2005
Posts: 4
|
| Posted: Tue Feb 22, 2005 8:58 pm Post subject:
Re: 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 |
|
| Back to top |
|
|
Niall Litchfield
*nix forums Guru Wannabe
Joined: 29 Apr 2005
Posts: 128
|
| Posted: Tue Feb 22, 2005 8:44 pm Post subject:
Re: Triggers and Window Service
|
|
|
"LuAnn" <bearpackexpress@hotmail.com> wrote in message
news:1109107224.509508.241380@g14g2000cwa.googlegroups.com...
| Quote: | 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 |
|
| Back to top |
|
|
LuAnn
*nix forums beginner
Joined: 22 Feb 2005
Posts: 4
|
| Posted: Tue Feb 22, 2005 8:20 pm Post subject:
Re: 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. |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Tue Feb 22, 2005 8:00 pm Post subject:
Re: Triggers and Window Service
|
|
|
LuAnn wrote:
| Quote: | Hi,
Is there a way to create an oracle Trigger that will start a window
service? I am trying to get the service away from running a timer.
Running Oracle 9i and windows 2K or XP
Thanks
|
Please explain what it is you are doing with more clarity. I can not
cipher "trying to get the service away from running a timer."
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
LuAnn
*nix forums beginner
Joined: 22 Feb 2005
Posts: 4
|
| Posted: Tue Feb 22, 2005 7:23 pm Post subject:
Triggers and Window Service
|
|
|
Hi,
Is there a way to create an oracle Trigger that will start a window
service? I am trying to get the service away from running a timer.
Running Oracle 9i and windows 2K or XP
Thanks |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
