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

I have successfully done what you are asking by using the utl_file function in 7.3. You will need to add the following to the init.ora:

        UTL_FILE_DIR = *
After you bounce the database use the FOPEN function this allows you to create a flat file to a specified directory. This is most effective inside a database trigger.

Matthias Gresz <GreMa_at_t-online.de> wrote in article <678gaq$u0h$1_at_news00.btx.dtag.de>...
> 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 Mon Dec 29 1997 - 00:00:00 CST