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 -> Re: Execute Unix command

Re: Execute Unix command

From: Craig Orson Oakland (COO I) <dotacion.nospam_at_st-helena.zzn.com>
Date: Mon, 20 Mar 2000 15:12:39 -0800
Message-ID: <8b6b6f$8qr@gap.cco.caltech.edu>


BENOIT DELPLACE <> wrote in message ...
: Hello,
:
: How can I execute a Unix system command from a Oracle 8 stored procedure?
:
: Thanks
:
: BD
:
: Ps : Sorry for my poor english, but i'm french !!!
: Ps 1 : A stored procedure with the unix command in argument will be better

I think the answer you want is to preface the command with '!' that will send the command through to the host (works the same way as in ftp - try it there first to see for yerself)

HTH --
Craig O. Oakland (COO I) Received on Mon Mar 20 2000 - 17:12:39 CST

Original text of this message

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