You are right Marc!! It was the login.sql file. If I remove the file, it
works fine. Does this mean that the default value of ECHO is OFF?
Suppose ECHO is set to ON deliberately, then while running the temp.sql
script the 'SET ECHO OFF' statement will always be echoed, isn't it?
Thanks regards,
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
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 'SQLset echo off'
I don't get that when running on W2K. Are you executing a login.sql or
glogin.sql script first? How are you invoking your temp.sql? Using the @
on the command line or redirecting input or typing it in directly?
What version of sqlplus? I tried it with 8.1.6.
Marc Perkowitz
- Original