DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Set Head off ?

  1. #1
    Join Date
    Jan 2001
    Posts
    642

    Set Head off ?

    Hi,

    In one of the data extract scripts, I am using
    set echo off
    set verify off
    set heading off
    set feedback off
    set pagesize 0

    But still in the spool file I see both the "sql statement" and also the Feedback (100 rows selected)

    What could be the reason? I have tried Heading off, feed off etc., but in vain.

    Thanks,
    Badrinath
    There is always a better way to do the things.

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Try these


    set feedback off
    set verify off
    set termout off
    set heading off
    set serveroutput off
    set echo off
    set show off


    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width