Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT:
temp.sql: --------- set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE ROWNUM < 10; set pagesize 1000 set feedback on set echo on --------- While running it always displays 'SQL>set echo off' before muffling the echo. Is there any way to stop this line from appearing? I vaguely remember that in some language you could put @ in front of the 'set echo off' command to suppress it. Is there something similar possible. TIA. Regards, Charu. -----Original Message----- Sent: Thursday, October 24, 2002 12:26 PM To: Multiple recipients of list ORACLE-L the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. >>> [EMAIL PROTECTED] 10/24/02 05:44AM >>> we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 8:13 AM > Environment: > Oracle 8.1.6 > AIX server behind a firewall > db is accessed by a Windows application running on a IIS web server > sitting outside the firewall > db uses port 1521 > > > After a flurry of email between the Unix admin and the 4 software vendors > concerned, all the fingers are now pointing at "that damn oracle > database". The Unix admin is asking two questions: > > 1) what Oracle is doing with the four ports 20,000 - 20,003 > 2) can he shut them down? > > > Any ideas are appreciated. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). ********************************************************* Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. ********************************************************* Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).