Re: Can you run shell script from insight the PL/SQL procedure?

I've done that in a SQL*Plus script, not a PL/SQL script, but you can try it. Precede the operating system command with a '!'.

Example: spool to a file, compress it, and rename it with a PID as part of the name:

spool filename
select yadda1, yadda2, yadda3
from blah_blah_blah
/
spool off
!compress filename.lst
!mv filename.lst filename.lst.$$.Z

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Robert Augustyn <augustyn_at_unn.unisys.com> wrote in article <6ji5m0$7gm$1_at_mail.pl.unisys.com>...
> Hi,
> I have a need to run operating system command from the pl/sql block
> is that possible?
> thanks for any info
> robert
Received on Mon May 18 1998 - 11:28:55 CDT