RE: Send output to a PC every N minutes
- From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
- To: <Ron.Reidy@xxxxxxxxxxxxxxxxxx>, <JBECKSTROM@xxxxxxxxx>, <rjamya@xxxxxxxxx>
- Date: Thu, 25 Aug 2005 09:43:47 -0700
What is the business problem? I can think of several viable solutions
depending upon what problem they are trying to solve. Do they need real
time notification? Are they polling to see if something changed? I've
used dbms_alerts in the past and a trigger to raise an alert. Then the
program on the PC can requery. It saves you from polling the heck out
of a table, but gives you feedback when the data changes per some
criteria.
Jim
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Reidy, Ron
Sent: Thursday, August 25, 2005 7:53 AM
To: JBECKSTROM@xxxxxxxxx; rjamya@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Send output to a PC every N minutes
Think of an IPC type of solution - dbms_pipe
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeffrey Beckstrom
Sent: Thursday, August 25, 2005 6:06 AM
To: rjamya@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Send output to a PC every N minutes
That's what we were thinking of. The problem with sql*plus is that
procedure has to end for output to get to screen. Then how do you
reinvoke the procedure again. DBMS_JOB won't send output to a client
PC.
>>> rjamya <rjamya@xxxxxxxxx> 8/25/05 7:54:17 AM >>>
What version? How do you want to send output? You could easily do this
using sqlplus or dbms_job. A procedure and a mechanism to otput is all
you need.
raj
On 8/25/05, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote:
Our developers have a requirement to query a table and send the
output to a PC every N minutes. Developers don't know Perl so looking
at some alternatives. I would hate to do it in Sql*plus since would
have to start sql*plus, connect, run procedure, exit and repeat. That
would be a lot of connecting.
Any other suggestions.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
________________________________
This electronic message transmission is a PRIVATE communication which
contains information
which may be confidential or privileged. The information is intended to
be for the use of the individual
or entity named above. If you are not the intended recipient, please be
aware that any disclosure,
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0),
and then delete it from your system.
Other related posts:
