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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPLUS input truncated error

Re: SQLPLUS input truncated error

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 25 Oct 1999 22:48:09 GMT
Message-ID: <7v2mn9$lj@gap.cco.caltech.edu>


Apparently you did not put a <CR> (press "Enter") after "spool off" in your script. "spool off" has 9 characters. If you finished typing "spool off" and then save, the end-of-file is immediately after it. SQL*Plus does not seem to like this (although the script will run without a problem other than the "Input truncated to 9 characters" message). To avoid this message, just press enter after "spool off" (so that the cursor is located in the begining of a new line), and then save the script.

Xuequn Xu, Oracle DBA
Caltech, Pasadena, CA

dennis liu (dliu_at_neostrata.com) wrote:
: I try to generate a script from sqlplus, the result file is fine except
: there is an "Input truncated to 9 characters" message at the end of
: script file generated. what is it means and how to fix it?
: I list the sql file bellow.

: thank you for your help

: --this script file runs under user 'sys'
: set feedback off heading off verify off echo off termout off
: set long 255
: spool sysgrant.xxx
: select 'grant select on '||OBJECT_NAME||' to '||'system;'
: from dba_objects
: where owner='SYS' and object_type = 'VIEW' and object_name like 'V%';
: spool off
Received on Mon Oct 25 1999 - 17:48:09 CDT

Original text of this message

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