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 HOST COMMAND FROM ORACLE7 SERVER-SIDE PL/SQL ENGINE

Re: EXECUTE HOST COMMAND FROM ORACLE7 SERVER-SIDE PL/SQL ENGINE

From: Jim Smith <james-detg.smith_at_ubs.com>
Date: 1997/12/18
Message-ID: <34991E46.A22DD1BB@ubs.com>#1/1 









Paul Pham wrote:



> hello everyone,

>

> Can we execute a host system command from Oracle7 server-side PL/SQL ??

>




Can't be done directly with O7.



The usual solution to this is to write a daemon process that listens on a
pipe (see DBMS_PIPE package) and executes commands. Your trigger can then
send messages along the pipe



Thomas Kite (tkyte_at_us.oracle.com) has a sort of SDK for pipe daemons
available



Jim Smith
Received on Thu Dec 18 1997 - 00:00:00 CST












Original text of this message













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