Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: EXECUTE HOST COMMAND FROM ORACLE7 SERVER-SIDE PL/SQL ENGINE
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)
> where ls is directory command.
>
> 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 .
Hi,
as far as I know this is only possible with version 8.
-- Regards Matthias Gresz :-)Received on Wed Dec 17 1997 - 00:00:00 CST