RE: Send output to a PC every N minutes

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <JBECKSTROM@xxxxxxxxx>, <rjamya@xxxxxxxxx>
  • Date: Thu, 25 Aug 2005 08:52:30 -0600

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.


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 = 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
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: