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

Vijay Damodaran wrote:
>
> 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

Hi,
We used to use database pipes to do this. Essentially, a ProC program always running on the server could unpack a pipe that was packed via a procedure running in the client. The contents of the pipe was the host command that had to be run. We used the "system" command within the ProC program to execute the OS command. Further to that, you could put the output anywhere you wanted, and/or use the ProC program to feed the output back.
Check out DBMS_PIPE package int $ORACLE_HOME/rdbms/admin.

Cheers,
Terry Received on Sun Jul 27 1997 - 00:00:00 CDT