I sent a mail in a while ago that explains how to set up a "polling" C Shell script that accepts Unix commands coming across a DBMS_PIPE.
Essentially, the shell script sits in an infinite loop polling the DBMS_PIPE and taking commands from it, executing them, and then re-runs itself. It can be stopped by passing a command such as SHUTDOWN through the pipe. If you want me to send on the code, drop me a note. Cheers, Kev -----Original Message----- Sent: 30 July 2002 20:57 To: Multiple recipients of list ORACLE-L OK, I checked Google and my own old mail and I know I've seen this here before, but can't find my notes, so please forgive this same old question... I need to execute a system call from within a PL/SQL block. Specifically, I am looking at starting out report request demons as part of a post startup trigger. Help? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
