Sorry to get on this thread so late... To answer Emre's question, we can do it if you have a extproc listener configured and have a external procedure to do the same.
Babu ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 8:53 AM > HOST is a SQL*Plus command only. > > --- John Weatherman <[EMAIL PROTECTED]> wrote: > > What about issueing a HOST command through dbms_sql? Not saying it > > will > > work (I haven't tried it) > > but it seems like it should. > > > > -----Original Message----- > > Sent: Friday, April 19, 2002 5:53 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, > > > > no, there's no way to do that through PL/SQL. > > If have the option of using java you can use the solution given by > > Tom Kyte > > at > > > http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:952229840 > > 241 > > > <http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:95222984 > > 0241> > > > > Regards, > > Mike Hately > > > > -----Original Message----- > > Sent: 19 April 2002 10:03 > > To: Multiple recipients of list ORACLE-L > > > > > > > > Hi all, > > Is it possible to rename files (e.g .txt files) on Unix by using > > PL/SQL? Is > > there a function to do that? > > > > > > Regards > > > > M.Emre HANCIOGLU > > Masterfoods Services GmbH > > ISI Application Support > > Tel : +49 2162 500-576 > > Fax: +49 2162 41497 > > E-Mail: [EMAIL PROTECTED] > > > > > > > > > ____________________________________________________________________________ > > ________________________ > > > > > > This email and any attached to it are confidential and intended > > only for the > > individual or > > > > entity to which it is addressed. If you are not the intended > > recipient, > > please let us know > > > > by telephoning or emailing the sender. You should also delete the > > email and > > any attachment > > > > from your systems and should not copy the email or any attachment > > or > > disclose their content > > > > to any other person or entity. The views expressed here are not > > necessarily > > those of > > > > Churchill Insurance Group plc or its affiliates or subsidiaries. > > Thank you. > > > > Churchill Insurance Group plc. Company Registration Number - > > 2280426. > > England. > > > > Registered Office: Churchill Court, Westmoreland Road, Bromley, > > Kent BR1 > > 1DP. > > > > > > > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Raube > 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: Babu Nagarajan 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).