Re: SQL*plus script 'Input truncated to 9 characters'

Yes,
this question get answered several times a week lately. Please try to query the newsgroup archives at www.deja.com
Your problem is (stupid as it may sound) you don't have a cr/lf after your last command spool off.
This is a 'feature' which exists more than 6 years, and Oracle is probably not going to repair it.

Hth,

--
Sybrand Bakker, Oracle DBA
Nobody <nobody_at_logica.com> wrote in message news:7v9lnr$jpp_at_romeo.logica.co.uk...
> I have writen a script in SQL*plus for oracle under NT which works ok,
> except that at the end I have a line saying 'Input truncated to 9
> characters'.
> All this script does is to:
> set feedback off
> set linesize 90
> set pagesize 50
> format a few columns
> spool to file
> select a few columns
> spool off.
>
> This error is quite annoying I've had a quick look at the environment
> options but there is nothing obvious. Any suggestions?
>
> Gary
>
>
>
Received on Thu Oct 28 1999 - 14:26:30 CDT