Re: Executing UNIX commands from Oracle

Richard Wark (warkr_at_vanadium.brooks.af.mil) wrote:

: What you are looking for is the HOST command in SQL*Plus. Host allows
: you to execute UNIX commands from within SQLPLUS. One problem, however,
: you cannot use the HOST command within a stored PL/SQL procedure or
: trigger. I have been looking into this for a month or so, and have not
: come up with a perfect solution, the only way I have found is rather
: cumbersome:

I don't think you are looking for the SQL*Plus HOST command. My guess is that you aren't using SQL*Plus as a front-end for a client server application. In any case, if you were, the O/S that the HOST command would execute in is the client O/S, not the server O/S.

Try using database pipes. You put a message in one end (the client side) and have a process (e.g. written in Pro*C) on the other end (the server side) polling for messages coming out of the pipe. Your server process then executes the appropriate server o/s command.

• Dan