Re: Help with SQL PLUS message 'Input truncated to ... characters'

From: Catherine Page <Catherine_at_treesong.demon.co.uk>
Date: Wed, 19 May 1999 21:21:05 +0100
Message-ID: <UZTtQDAx0xQ3Iwva@treesong.demon.co.uk>

In article <MPG.11ad32fd257f0b81989681_at_news.btx.dtag.de>, Christian Cohrs <Christian.Cohrs_at_t-online.de> writes
>

Snipped
>> The problem is, I keep getting a message following some queries,
>> for example:
>> 'Input truncated to 9 characters'
>>
>> the number varies occasionally, but not in an obvious way.
>>
>> I have tried altering column formats, length of headings, setting
>> numwidth but can't trace the problem. As it is not an 'error' message I
>> can't find it in error message listings. I have been trying for weeks to
>> get rid of this message, can anyone spot the problem!
>>
>As you say this is only a message, nothing to worry about.
>I guess you run SQL-Plus scipts like this :
>
>SELECT...
>FROM...
>WHERE...
>/
>
>The position that causes the message is the '/' in the end.
>I can't remember the exact reason (have to check this at work)
>but it has to do with spaces behind the '/' or in the next line.
>Try to remove all whitespace behind the '/' except for one
>carriage return.

Thanks very much Christian, the assignment has got to be in tomorrow, and this was really silly but annoying! --
Catherine Page Received on Wed May 19 1999 - 15:21:05 CDT