Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Send output to a PC every N minutes

RE: Send output to a PC every N minutes

From: Kennedy, Jim <jim_kennedy_at_mentor.com>
Date: Thu, 25 Aug 2005 09:43:47 -0700
Message-ID: <EF25DB6D87DD1A469C80A312C63C3B4C044D1C04@SVR-ORW-EXC-07.mgc.mentorg.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reidy, Ron Sent: Thursday, August 25, 2005 7:53 AM
To: JBECKSTROM_at_gcrta.org; rjamya_at_gmail.com Cc: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jeffrey Beckstrom Sent: Thursday, August 25, 2005 6:06 AM
To: rjamya_at_gmail.com
Cc: oracle-l_at_freelists.org
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_at_gmail.com> 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_at_gcrta.org> 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. 


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 25 2005 - 11:45:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US