Re: Help! What causes the message: Input truncated to 9 characters ??
Date: Fri, 6 Oct 2000 00:09:15 +0200
Message-ID: <970849687.28683.5.pluto.d4ee154e_at_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>
[Quoted] Could anybody be so kind to explain me how to get rid of that last line?
-- VladimirReceived on Fri Oct 06 2000 - 00:09:15 CEST
/*****************************************************/
Everything should be as simple as possible, but no simpler. -Albert Einstein
/*****************************************************/