Re: Trivia question - not of any practical use.

The easiest solution I can think of is to set spool off within the script.

Dennis

Charu Joshi wrote:
>
> 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.
>
> >>> adar76_at_inter.net.il 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 <ORACLE-L_at_fatcity.com>
> 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: dondealy_at_teleport.com
> >
> > 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il
>
> 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: ListGuru_at_fatcity.com (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: Gsais_at_co.palm-beach.fl.us
>
> 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: ListGuru_at_fatcity.com (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: joshic_at_mahindrabt.com
>
> 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: ListGuru_at_fatcity.com (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: Dennis M. Heisler
  INET: dheisler_at_binghamton.edu

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: ListGuru_at_fatcity.com (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).