Re: LAUNCHING EXTERNAL PROCESS FROM TRIGGER

Someone posted this snippet a while back for the latest version of pl/sql

PROCEDURE shell (sys_cmd IN VARCHAR2)

	IS
	DECLARE
		sys_file UTL_FILE.FILE_TYPE;
	BEGIN
		sys_file := UTL_FILE.FOPEN (' | \bin\', 'sh',  'W');
		UTL_FILE.PUT(sys_file, sys_cmd);
		UTL_FILE.NEWLINE(sys_file);
		UTL_FILE.FCLOSE(sys_file);
	END;

to do it with DB 7.1.6 we coded a daemon as per the instructions in the oracle DBMS PIPE tech bulletin which I just made available again at url http://www.sep.bnl.gov/is/oracle/dbmspipe.htm. You need ProC to compile this beast.

On Fri, 13 Dec 1996 19:11:19 GMT, slc_at_stevensons.co.nz (Steve Chell) wrote:

>Is it possible for a stored procedure or database trigger
>to launch an independant server-side process (such as mailx,
>or any other non-oracle process)? Our database is version 7.1.6
>running under Solaris.
>
>(We don't have OCI or PRO*C, which I suspect we need to do
>this sort of thing.)
>
>Thanks in advance ...
>
>Steve Chell
>slc_at_stevensons.co.nz
>
>
Received on Sat Dec 14 1996 - 00:00:00 CST