The command that I gave you will suppress the dbms_output kind of messages. Looks like you are running a direct sql. Try creating a .sql file and invoke the sqlplus in the silent mode.

Code:
        SQLPLUS -S username/password @script.sql
In the script
Code:
     set feedback off
     set heading off
     set verify off
     set termout off
     spool output_file_name
     your sql statement
     spool off
     exit
Sam

[Edited by sambavan on 09-30-2002 at 06:47 PM]