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_at_autumn.news.rcn.net>
Date: Wed, 12 May 1999 12:15:51 -0400
Message-ID: <7hc9a6$8e2$1_at_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> _at_<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 - 18:15:51 CEST