Re: SQL*Plus won't let me reset TERMOUT

In article <Ng3kgD1w165w_at_vllyoak.resun.com> jp_at_vllyoak.resun.com (Jeff Perry) writes:

> I'm writing a SQL report that I'll embed within
> a C program using a system call. I'm attempting to
> keep SQL*Plus from displaying the results of
> a select statement that loads a variable. This
> is being attempted from a Unix SVr4 system:
>
> sqlplus -s <<EOF
> system/password
> set termout off
> column name NEW_VALUE DBname
> select lower(name) name from V$database;
> TTitle center 'Database = ' DBname
> [snip]
>
> EOF
>
> Even though TERMOUT is set to OFF, it displays. If
> the same commands are executed interactively, no
> display occurs, that is, it works as attended.

TERMOUT only supresses output when a command file is run e.g. you have used START, _at_ or @@.

You could try the NOPRINT option of the COLUMN command:

        column name NEW_VALUE DBname NOPRINT

Chris

-- 
Christopher Jones, cjones_at_au.oracle.com