Re: "Input Truncated" Message

The "Input truncated..." message comes from SQL Plus when you use something like Microsoft's Notepad to create an input script. Put a Carriage Return character at the end of the last line (and don't type any spaces or anything else after that), and the message will go away.

Steve Cosner

In article <357BF624.9358916_at_deere.com>, John P. Higgins <jh33378_at_deere.com> wrote:
>If she would add an 'exit' statement at the end of her SQL, the message will
>go away.
>
>Michael A. Rife wrote:
>
>> I have a developer who is writing a SQL*Plus script to run nightly in a
>> Unix CRON job. She is spooling the output of the SQL*Plus script to a
>> flat file. She receives this message at the end of the file: "Input
>> truncated to 10 characters". The SELECT statement executed with no
>> problems. The data file was not missing any data. I ran the same Korn
>> shell script and SQL*Plus script in my Unix account and did not get this
>> message. We are running Sun Solaris and Oracle 7.3.3.
>>
>> What causes this message to occur? Is there a SQL*Plus SET option that
>> can be changed to correct the cause or supress this message?
>>
>> Thanks for any help or ideas. Please respond via net posting as well as
>> e-mail to MRife_at_Admin.USF.edu
Received on Mon Jun 08 1998 - 00:00:00 CDT