Re: Can a stored procedure execute a unix command?

From: R. Scott Hunter <robertscothunter_at_aol.comnospam>
Date: 04 Jan 2001 05:31:00 GMT
Message-ID: <20010104003100.29394.00001464@ng-fk1.aol.com>

It's not as gruesome as it sounds; you are in effect rolling your own listener for the UNIX side of things. The PL/SQL documentation provides sample code that should be helpful.

A kluge that MIGHT meed your needs is to use the UTL_FILE package to write to a UNIX file with the command line you want executed, and a simple shell script daemon that periodically executes the command lines in that file and then truncates it with a > until the next cycle. (I said it was a kludge.)

R. Scott Hunter
Please respond to: rshunter_at_navy.org
GO NAVY!

Received on Wed Jan 03 2001 - 23:31:00 CST