Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to eliminate "Input truncated..." msg

Re: how to eliminate "Input truncated..." msg

From: Marly <marlythomas_at_hotmail.com>
Date: 22 Feb 2002 09:29:12 -0800
Message-ID: <3ee16386.0202220929.403ffabe@posting.google.com>


miker <mdent12_at_none.com> wrote in message news:<9njc7uor6fka84uq3lrnkqbnv09d4thcd5_at_4ax.com>...
> Is there any way to get rid of "Input truncated to xx characters" and
> "xx rows selected." msg? tia.

You can use:
set echo off
set termout off
set feedback off
spool logfile.log
select * from table;
spool off
exit

and use the sqlplus silent option as in sqlplus -s user/pw @script.sql Received on Fri Feb 22 2002 - 11:29:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US