Re: Perform operating system's commands in PL/SQL?

Here are the steps that will make this work: 1. Write a daemon process that reads a certain oracle pipe that runs on the OS; I've only tried it on UNIX using Pro*C. 2. You need write PL/SQL that sends and receives messages through that pipe. The outgoing message would be the UNIX command while the incoming message is the result of that command. I would place this in a package of some sort.

Well, that is the overview of that. I saw an article on it in the old Oreview magazine, which is still archived: www.oreview.com (it's called something else now but they have archives of the old magazine).

Good luck.

Chi

Jhansi Rani wrote:

> Zhuang Li wrote:
> >
> > Is it possible to issue an operating system command within PL/SQL or
> > Forms4.5? As we know such option is availble both in Fortrain and C.
> > For Example, in C we can use "system" function to perform operating
> > system commands.
> >
> > Zhuang Li from Liverpool University
>
> Hi,
>
> You can also use HOST(command) just like system command.
>
> Regards
> Jhansi
Received on Mon Mar 02 1998 - 00:00:00 CET