Re: Help! What causes the message: Input truncated to 9 characters ??

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 6 Oct 2000 00:09:15 +0200
Message-ID: <970849687.28683.5.pluto.d4ee154e@news.demon.nl>

One: by avoiding crossposting to the whole of Usenet Two: by hitting return after 'off'

Regards,

Sybrand Bakker, Oracle DBA

"Vladimir" <servol_at_nospam_ultinet.com> wrote in message news:39dcead1_2_at_nntp2.nac.net...
Hi everyone!

I am trying to create a flat file using spool command. The whole thing look like this:

set verify off
set heading off
set underline off
set feedback off
set lines 80
set echo off
set termout off
set space 1
set pagesize 0

column geid format A10
column EMPLASTNAME format A30
column EMPFIRSTNAME format A30

Spool D:\Non_access_report\geid.txt

SELECT distinct CDR_ACCESS_RULE.GEID,

                EMPLASTNAME,
                EMPFIRSTNAME
FROM   CDR_ACCESS_RULE,
       ORDEMPLOYEEINFO

where CDR_ACCESS_RULE.GEID = ORDEMPLOYEEINFO.EMPGEID (+) order by CDR_ACCESS_RULE.GEID;

Spool off

I am getting all I want PLUS a message at the end of the file: Input truncated to 9 characters

i.e.

 ..........................................................................
7777778778 Gor      Sima

3564811111 Smith Inna
Input truncated to 9 characters
<EOF>

Could anybody be so kind to explain me how to get rid of that last line?

--
Vladimir


/*****************************************************/

Everything should be as simple as possible,
but no simpler.                     -Albert Einstein


/*****************************************************/

Received on Thu Oct 05 2000 - 17:09:15 CDT