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

Ok, sorry, I was answering with respect to a procedure within Forms.

No need for the petty small-minded comments from Mr O'Connell though

EdwardAwad_at_webtv.net wrote in message <713na8$c1t$1_at_nnrp1.dejanews.com>...
>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
> 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 Wed Oct 28 1998 - 19:18:53 CET