Re: Calling UNIX commands from PL/SQL scripts...

Hello there,

You need to have a server side program which will on the background. Ideally it can be a Pro*C program, the database trigger can write a message into a dbms pipe, on receiving the message, the Pro*C program can start its own process.

Pls note, that these sessions are independent of one another, hence commit given on 1 session will not commit for the another. In our system, we are using DBMS_PIPE extensively, it really works!!!!

Regards

N.Prabhakar

Vijay Damodaran <vijayd_at_nortel.com> wrote in article <33D8D699.317E_at_nortel.com>...
> Hi,
>
> I want to call a UNIX command from within a PL/SQL script. Is there
> anyway to do this. This PL/SQL script is a packaged procedure and
> is called from a Forms 4.5 trigger.
>
> Since the process must run on the server side due to some mounting
> issues, I cannot use Forms 4.5's host command. Is there a
> corresponding host command for PL/SQL on the server side.
>
> Thanks in advance for ur help.
>
> VJ.
> --
> Vijay Damodaran
> vijayd_at_nortel.com
> Work: (972) 685-8150
>
Received on Thu Jul 31 1997 - 00:00:00 CDT