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

Home -> Community -> Usenet -> c.d.o.server -> Re: Input truncated

Re: Input truncated

From: Daan Eenkhoorn <daan_at_dsv.nl>
Date: Mon, 7 Sep 1998 16:41:29 +0200
Message-ID: <6t0r9j$19tm$1@ns0.klm.nl>


Make sure there is a carriage return line feed directly following the last character of your sql statement. This may sound stupid, but that's how it works. Although I have a feeling this 'feature' is undocumented...

Hth,

Sybrand Bakker, Oracle DBA

Ivan Bajon wrote in message <6t0a7q$e58$1_at_news1.tele.dk>...
>I have a simple select in a script which I run from sqlplus. The result is
>spooled to a file but at the end of the file, I get the message "Input
>truncated to 9 characters" - which I don't get when I run the query
>directly. Would someone please tell me how to get rid of the message?
>
>Thanks in advance
>- Ivan Bajon
>
>
Received on Mon Sep 07 1998 - 09:41:29 CDT

Original text of this message

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