RE: Calling UNIX Shell Scripts from a Stored Procedure

How about a java stored procedure using a runtime object to exec the script?

Jeff T
thomasje_at_tce.com

-----Original Message-----
From: David Mauzey [mailto:dmj_at_mdcl.com] Sent: Friday, June 16, 2000 11:48 AM
To: Multiple recipients of list ORACLE-L Subject: Calling UNIX Shell Scripts from a Stored Procedure

Can anyone give me any advice on how to execute a simple UNIX shell script from an Oracle stored procedure? The UNIX shell script will simply use SQL*Loader to load a file into the database. I have heard whispers about several methods to accomplish this task; however, I haven't yet seen any examples or documentation on the subject.

Thank you.

David Mauzey
ppoONE.com
a MedicalControl Company
(214) 267-3410

dmj_at_ppoone.com

-- 
Author: David Mauzey
  INET: dmj_at_mdcl.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).