Calling a UNIX Shell Script from PL/SQL procedure
From: <ds236_at_nni.com>
Date: Tue, 20 Oct 1998 13:16:43 GMT
Message-ID: <70i2fr$fv6$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] 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?
Date: Tue, 20 Oct 1998 13:16:43 GMT
Message-ID: <70i2fr$fv6$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] 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 20 1998 - 15:16:43 CEST