Re: call of a unix script from a stored proc

From: Alexey M. Reshetov <real_at_kpbank.ru>
Date: 30 Jul 1998 01:09:24 GMT
Message-ID: <6poh44$gvm$2@home.kpbank.ru>

Eric wrote:
: Is it possible to execute a unix command from within a stored proc?
: and if so, how?

: Thanks

You should use DBMS_PIPE with unix daemon. Look in Oracle7 Server Application Developer's Guide. There are daemon.sql and daemon.pc examples.
Also in Oracle8 you can use External Procedures. Look into Chapter 10 of PL/SQL User's Guide and Reference, Release 8.0.

---

Alexey Reshetov
real_at_kpbank.ru Received on Wed Jul 29 1998 - 20:09:24 CDT