Re: Calling a UNIX Shell Script from PL/SQL procedure

[Quoted] In article <712vja$8s2$1_at_newsreader1.core.theplanet.net>,   "Pete Hawdon" <pete_at_hawdon.freeserve.co.uk> wrote:
> Have you tried the 'host' command?
>
> 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
>
>

I knew that the HOST command could be executed from SQLPLUS and FORMS 4.5/5.0 [Quoted]  Only. I did not know that it could be excecuted from a PL/SQL procedure or function. could'it be? -- Edward Awad Oracle Developer

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 06:56:24 CET