Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Calling a UNIX shell script from PL/SQL procedure?

Calling a UNIX shell script from PL/SQL procedure?

From: <ds236_at_nni.com>
Date: Tue, 20 Oct 1998 13:14:37 GMT
Message-ID: <70i2bt$fm4$1@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 Tue Oct 20 1998 - 08:14:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US