Re: Help : Calling external programs in PL/SQL

If you are using Oracle version 8, then apparently there is a way of loading
external programs that can then be executed from the server. I do not use
Oracle 8.

If you are using version 7.3.X then the standard way is to create a public
pipe that your PL/SQL program sends commands down. These must then be read by a Pro* program that is waiting on the pipe (via a PL/SQL anonymous block). When a command is received by the program it executes it using the necessary operating system calls and loops around to wait on the pipe again.

Regards

Jeon Kyonghun wrote:

> 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

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7678944
*************************