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

Home -> Community -> Usenet -> c.d.o.tools -> Help! What causes the message: Input truncated to 9 characters ??

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@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 - 15:55:23 CDT

Original text of this message

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