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 UNIX shell script from PL/SQL procedure

Calling UNIX shell script from PL/SQL procedure

From: <ds236_at_my-dejanews.com>
Date: Mon, 19 Oct 1998 19:31:55 GMT
Message-ID: <70g43b$uts$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 Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Oct 19 1998 - 14:31:55 CDT

Original text of this message

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