|
Re: is it possible to run UNIX command from PL/SQL procedure [message #370457 is a reply to message #370396] |
Tue, 28 September 1999 07:48 |
Sean Miller
Messages: 12 Registered: December 1998
|
Junior Member |
|
|
evgeny's answer "oracle 7.3" is not strictly true. 7.3.2.3 certainly doesn't support "host" commands though I know they are available in a later version (not sure which).
quite a good way to do this sort of thing in versions that don't have these functions is using a database pipe. write a pro'c' daemon which will sit listening on a pipe for a command and will then run it and send the output back up the pipe. You can then write some database procedures/functions to communicate with the daemon and run these from forms,reports and pl/sql.
at one stage I posted an oracle document with example code on this forum - it's probably still around somewhere!
sean
|
|
|