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

On Mon, 26 Oct 1998 23:13:12 -0000, 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
>
>

It would be nice if people would read the original message before offering advice. The "host" command is a sqlplus command, not a sql or pl/sql command. If you are using version 8 and up there is an ability to call external procedures.
If you are using version 7.xx then the only way to execute a non-oracle command is to pass it to the operating system by way of sql pipes.

-- 

Don O'Connell -- email  - donroc_at_home.net