Re: Calling a UNIX Shell Script from PL/SQL procedure
From: Ulf Magnusson <ulf.magnusson_at_briunix.kiedt.ericsson.se>
Date: Wed, 21 Oct 1998 10:42:34 +0200
Message-ID: <70k659$2u5_at_newstoo.ericsson.se>
Date: Wed, 21 Oct 1998 10:42:34 +0200
Message-ID: <70k659$2u5_at_newstoo.ericsson.se>
Hi,
The sign '!' is a SQL*Plus thing.
So in a pl/sql block you are not "in" SQL*Plus even if you run it in
SQL*Plus.
/Ulf
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 Wed Oct 21 1998 - 10:42:34 CEST