Re: How to execute HOST command from strored procedure

From: Rebecca R. Aponte <aponte_at_destin.gulfnet.com>
Date: 1996/03/25
Message-ID: <4j4t1o$rac_at_server.cntfl.com>#1/1


You want to use host to communicate with the operating system. PL/SQL will not support the HOST command, but SQL and SQLFORMS will. In my applications I send mail to a lot of user. I create a temp table to storage the mail command (in your case you operating system command line) I spool the table out and I se host ffrom sql to execute the file. But It is what it works for my requirement. (By the way no compilation required). Received on Mon Mar 25 1996 - 00:00:00 CET

Original text of this message