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

Home -> Community -> Usenet -> c.d.o.server -> Re: Running Shell Script From Stored Proc

Re: Running Shell Script From Stored Proc

From: <rtproffitt_at_my-dejanews.com>
Date: Wed, 12 May 1999 16:23:48 GMT
Message-ID: <7hc9uh$bhg$1@nnrp1.deja.com>


We were running Oracle 7.3.4 on Sequent Unix. We wanted a stored procedure to perform a transaction with access to a mainframe (Unisys Mapper). We experimented with the back end launching a shell script. It can return simple answers but is not designed for high volume, multi-user access.

Another similar way is to run daemons in crontab that watch for flag files. Oracle backend writes the flag file, which causes the daemon to launch the process...

Robert Proffitt

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 11:23:48 CDT

Original text of this message

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