Re: SET HEADING OFF not working

On 14-Nov-2013, p.pandey003_at_gmail.com wrote:

> I was using below in a script but still getting the sql query with the
> output in a spool file.
>
> set feedback off
> set heading off
> SET TERM OFF
> set echo off
> set tab off
> set serveroutput off
> set show off
> set trimspool on
> set pagesize 0
>
> Please help on this how to fix it.

Try adding

SET PROMPT '' But also, for good form and completeness, add

SET TRIMOUT ON Also, when you run sqlplus add /s to the command line. Received on Thu Nov 14 2013 - 14:40:22 CET