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

From: Vladimir <servol_at_nospam>
Date: Thu, 5 Oct 2000 16:55:23 -0400
Message-ID: <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

[Quoted] 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>

[Quoted] 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 - 22:55:23 CEST