Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to run Unix scripts from Stored Procedures
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
![]() |
![]() |