Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Help! What causes the message: Input truncated to 9 characters ??
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
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 InnaInput truncated to 9 characters
Could anybody be so kind to explain me how to get rid of that last line?
-- VladimirReceived on Thu Oct 05 2000 - 15:55:23 CDT
/*****************************************************/
Everything should be as simple as possible, but no simpler. -Albert Einstein
/*****************************************************/
![]() |
![]() |