Re: Running Shell Script From Stored Proc

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 12 May 1999 12:15:51 -0400
Message-ID: <7hc9a6$8e2$1@autumn.news.rcn.net>

Hi,

Check out PL/SQL external procedures. From what I recall any operating system command can be invoked as an external procedure. Thus the command:

sqlplus <user>/<password> @<scriptname>

will work.

regards

Jerry Gitomer

yitbsal_at_statcan.ca wrote in message <7ha43v$jbh$1_at_nnrp1.deja.com>...
>Hi,
>
>What is the best way run a shell script from a stored procedure? In
>general, what is the best way to run any operating system command and
>get a return value?
>
>My environment is Oracle 8 on a Unix box.
>
>Thanks,
>Salaam Yitbarek
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Wed May 12 1999 - 11:15:51 CDT