Re: Calling a UNIX Shell Script from PL/SQL procedure
From: Pete Hawdon <pete_at_hawdon.freeserve.co.uk>
Date: Mon, 26 Oct 1998 23:13:12 -0000
Message-ID: <712vja$8s2$1_at_newsreader1.core.theplanet.net>
Date: Mon, 26 Oct 1998 23:13:12 -0000
Message-ID: <712vja$8s2$1_at_newsreader1.core.theplanet.net>
[Quoted] Have you tried the 'host' command?
[Quoted] eg host(commandstring)
where commandstring is the name of the script including any parameters.
ds236_at_nni.com wrote in message <70i2fr$fv6$1_at_nnrp1.dejanews.com>...
>In a pl/sql script, I want to call a shell script
>that kicks off sqlldr and loads a data file. I was
>told that I could issue the command
>!nameofshellscript inside the procedure and this
>would call the script. However, the pl/sql
>compiler does not like the '!' symbol. How should
>this be done, or can it be done?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Oct 27 1998 - 00:13:12 CET