Home » RDBMS Server » Server Administration » is it possible to run UNIX command from PL/SQL procedure
is it possible to run UNIX command from PL/SQL procedure [message #370396] Sat, 18 September 1999 01:21 Go to next message
evgeny
Messages: 1
Registered: September 1999
Junior Member
Is it possible to run UNIX command from PL/SQL procedure ?
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 Go to previous message
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
Previous Topic: Want more info about Raise_Application_Error Func.
Next Topic: UTL_FILE Get_line --- NO_DATA_FOUND problem
Goto Forum:
  


Current Time: Wed Oct 21 11:52:22 CDT 2020