Re: Help : Calling external programs in PL/SQL

From: David Russell <user_at_msn.com>
Date: 1997/11/25
Message-ID: <01bcf9e7$737c0340$594195c1@thor>#1/1

If you are using Oracle 7 then you can create a pipe with DBMS_PIPE and have a watchdog program listening for messages on the pipe. You PL/SQL program then puts a message on the pipe and when the watchdog collects the message it executes the external program.

If you are using Oracle 8 then you can use the External Procedure facility that allows you to make trusted calls to external programs (via the NET8 Listener)

Both these approaches are described in the Orcale Application developers Guides.

Regards
David Russell

Jeon Kyonghun <khjeon_at_ktnet.co.kr> wrote in article <347AB87A.E2214596_at_ktnet.co.kr>...
> Hi there.
> Currently I'm developing a small system using oracle.
> And I have to execute some external programs in PL/SQL stored
> procedures.
> Is there any one who knows how to do that?
> Thanks in advance.
>
> Jeon
>
> --
> Jeon Kyong Hun Korea Trade Network
> Phone : 82-2-551-0412 Fax : 82-2-551-2268
> Chollian : jeonkh Pager : 015-920-5809
> mailto:khjeon@ktnet.co.kr http://www.ktnet.co.kr/~khjeon
>
>
>
Received on Tue Nov 25 1997 - 00:00:00 CST