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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Can you execute Unix command through PL/SQL?

Re: Can you execute Unix command through PL/SQL?

From: Vic Abell <abe_at_cc.purdue.edu>
Date: Sun, 31 Dec 2000 19:53:41 +0000 (UTC)
Message-ID: <92o2s5$bcu$1@mozo.cc.purdue.edu> 






yakub <yakub_at_erols.com> writes:



>I'm trust that someone outhere know how to execute a Unix command or an

>executible from the Unix OS through PL/SQL?  I am using Oracle 8.0.5 and

>8.1.5




One way to do this is via an Oracle external procedure your PL/SQL
code calls.  The call goes via RPC to the TNS listener.  It loads
your procedure's code from your shared library, then executes it.
Your code can fork() and exec() the Unix executable.
Received on Sun Dec 31 2000 - 13:53:41 CST












Original text of this message













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