Re: SQLPlus question

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Wed, Jul 07, 1999 at 09:46:54AM -0700, Joe wrote:
> In Oracle SQL Plus, what (if any) environment optons can be changed to
> address the error message "input truncated to 16 characters" ?
>
> Error occurs in a select statement.

Are you trying to run a "script file" with @ or "start"?

I've seen this message if the script file did not have a carriage-return
/line-feed (or just line-feed under Unix) on the last line.  SQL*Plus
assumes this means that the file was truncated somehow, and prints the
above the message as a warning.  If this is your situation, you'll find
that the last line of the script file is 16 characters long.

You can get rid of the message by making sure the last line of the
script file gets properly terminated.  Many text editors will
automatically do this; you would just need to open the file and then
save it again.  If your editor doesn't do this, you might need to
manually hit <enter> at the end of the file, or something.

Or, under Unix you should be able to just say
   echo >> script.sql
(Be sure to have two ">" or you'll erase your script!)  The "echo"
will generate a proper line termination sequence, which will then be
appended to the script.

Hope this helps.

                                                Nathan

----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/