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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to run Unix scripts from Stored Procedures

Re: How to run Unix scripts from Stored Procedures

From: Bruno S Fernandes <bruno-s-fernandes_at_telecom.pt>
Date: Tue, 12 Jan 1999 16:25:22 -0000
Message-ID: <77ft1l$mqa$1@pthp35.telecom.pt>

zoaibs_at_my-dejanews.com wrote in message <77c01i$o82$1_at_nnrp1.dejanews.com>...
>Hi,
>
>Can anyone show me a way of calling unix scripts / shell commands from
Oracle
>stored procedures.
>
>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Try to use the DBMS_PIPE package to exchange messages between the Oracle Server and UNIX. The message can be the command that you want to execute. Be sure to have a program always running that is listening to the pipe, and when the command appears execute it. Received on Tue Jan 12 1999 - 10:25:22 CST

Original text of this message

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