Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |