Re: Help - SQL*Plus termout off not working

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/05/25
Message-ID: <kclqiskfpc45ikn3f7ctq6ksh1rgjd9mmp_at_4ax.com>#1/1

You can only turn TERMOUT off when you are executing a SQL*Plus script file. As far as SQL*Plus is concerned, you are executing it interactively. Try something like this:

sqlplus -s $USER/$PASS _at_somefile.sql

Then make sure that somefile.sql contains the SQL*Plus commands that you want to execute.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Thu, 25 May 2000 07:08:48 -0700, lifter <pummellerNOpuSPAM_at_netscape.net.invalid> wrote:

>I need to spool query output to a flat file, and I want to
>suppress the screen output. I am entering Sql*Plus through
>a Unix shell script and setting TERMOUT OFF. However, the
>output file is still scrolling to the screen. Is there
>anything else I can do to stop it?
>----------------
>sqlplus -s $USER/$PASS << EOF
>SET TERMOUT OFF
>SET HEAD OFF
>SET VERIFY OFF
>SET ECHO OFF
>SET FEEDBACK OFF
>SET LINES 10000
>SET PAGES 0
>SET TRIMSPOOL ON
>
>SPOOL ${DIR}/backup.txt
>
>SELECT
> dd.typ||chr(124)||
> dd.inv||chr(124)||
> dd.rule||chr(124)||
> TRIM(TRAILING FROM dd.code)||chr(124)||
> dd.orig_num||chr(124)||
> dd.cdt||chr(124)||
> dd.ctime
>FROM del_detail dd;
>SPOOL OFF;
>EOF
>------------
>Thanks!
>
>
>
>
>* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Thu May 25 2000 - 00:00:00 CEST