Re: Host command

Douglas Boehme wrote:
>
> Douglas Boehme wrote:
> >
> > I'm trying to issue the Host command in a trigger in Oracle 7.1 on NT.
> > The problem I'm having is trying to pass the value contained in a
> > variable as a command line argument. What's the best way to do this?
> >
> > Thanks,
> > Douglas Boehme
> > boehmed_at_rad1.pcmail.ingr.com
>
> From what I've found, it seems that the "Host" command is only available
> in SQL Plus. Is that true? If so, is there a command to run
> executables residing on the NT server from a trigger in Oracle 7.1?
>
> Thanks,
> Douglas Boehme

I use the HOST command in PL/SQL triggers in forms 4.5. I create the command line as a character variable, the issue the HOST command, for example:

declare

   v_cmmand varchar2(200);
begin

   v_command := '<command> <arg1> <arg2> ...';    host (v_command);
end;

Hope this helps.

marty_at_amelia.sp.trw.com Received on Fri Aug 09 1996 - 00:00:00 CEST