Re: EXECUTE HOST COMMAND FROM ORACLE7 SERVER-SIDE PL/SQL ENGINE

You can use the DBMS_PIPE package. Read about it, if you still need help, email me.

Paul Pham wrote:

> hello everyone,
>
> Can we execute a host system command from Oracle7 server-side PL/SQL ??
> I know we can do it in SQLFORMS, SQLPLUS or in C via the standard
> library.
>
> for exmaple in SQLFORM ---> HOST(command name)
> SQLPLUS ---> SQLPLUS> HOST command name
> C ---> system(command name)
> in UNIX it may look like :
> SQLFORM ---> HOST(ls)
> SQLPLUS ---> SQLPLUS> HOST(ls)
> C ---> system(ls)
>
> I need to write a server-side database trigger that fire in response to
> "INSERT" events. The trigger need to call host computer to execute the
> LOCAL SYSTEM HOST COMMAND.
>
> our Oracle server is 7. I looked in to Oracle server-side built-in
> packages. Can not find a way to call host command from Oracle-Supplied
> stored procedure or function that do just that.
>
> is there a patch from Oracle or third-party product or even in Oracle7
> that allow to do that. Please reply ASAP to:
>
> phamp_at_argprod.elan.af.mil
>
> Thanks very much .
>
> Paul
Received on Sat Dec 27 1997 - 00:00:00 CET