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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with SQL PLUS message 'Input truncated to ... characters'

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

From: Alton Ayers <altona_at_ditw.com>
Date: Wed, 19 May 1999 16:50:35 -0400
Message-ID: <3743241B.CACC20C@ditw.com>


This happens when there is no new-line after the "/".

Catherine Page wrote:

> I have got a problem using SQL*Plus: Release 3.3.3.0.0
> supplied with Personal Oracle7 Release 7.2.2.3.1 - 90 day trial license
>
> With the distributed and replication options
> PL/SQL Release 2.2.2.3.1 - Production
>
> 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!
> --
> Catherine Page
Received on Wed May 19 1999 - 15:50:35 CDT

Original text of this message

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