Home » SQL & PL/SQL » Client Tools » Input truncated to 1 characters
Input truncated to 1 characters [message #39795] Mon, 12 August 2002 05:50 Go to next message
sridhar
Messages: 119
Registered: December 2001
Senior Member
While creating/replacing a procedure or a package(in SQL*PLUS) I keep getting a message "Input truncated to 1 characters", Can anyone tell me what does this mean and how to make sure this doesnt not appear. Though this does not cause a problem I am just curious to know.

Regards
Sridhar
Re: Input truncated to 1 characters [message #39796 is a reply to message #39795] Mon, 12 August 2002 06:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10679
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the message is becuase, there is no carriage return in the sql*plus script file.
just add a '/' at the end of stored proced script( in the last line).
it should work fine.
but, if you have a '/' in a sql script ( issuing sql statements) beware, the same sql will be executed again.
ie .,. the statement will be execute twice

Re: Input truncated to 1 characters [message #39799 is a reply to message #39795] Mon, 12 August 2002 07:57 Go to previous messageGo to next message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
Message: "Input Truncated To 'N' Characters" is received when running a script
at the SQL*Plus prompt.

This message is caused by the lack of a carriage return (CR) at the end of the
last line of the script.

Solution:
---------
Go to the end of the last line, hit delete, and then insert a CR. Save the
script.
Re: Input truncated to 1 characters [message #41768 is a reply to message #39795] Thu, 30 January 2003 09:49 Go to previous messageGo to next message
Lavanya Milton
Messages: 1
Registered: January 2003
Junior Member
The message 'Input truncated to 1 characters' in my case was corrected when I added some trailing spaces to the file. I already had the '/' in my file. Still I was getting this error. Then when I tried pressing 'Enter' a couple of times, I guess it got the carraige returns needed and the error was corrected.
Re: Input truncated to 1 characters [message #653609 is a reply to message #39795] Tue, 12 July 2016 06:14 Go to previous messageGo to next message
sanjay_mishra
Messages: 2
Registered: July 2016
Location: Kolkata
Junior Member

1) Go to the last line of the the script and after / press enter .It worked for me .Overall there must be an additional line in the end .
Re: Input truncated to 1 characters [message #653611 is a reply to message #653609] Tue, 12 July 2016 06:36 Go to previous messageGo to next message
John Watson
Messages: 7188
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

It is good to see a new member providing an answer rather than a question. However, the topic is from 13 years ago Smile
Re: Input truncated to 1 characters [message #653612 is a reply to message #653611] Tue, 12 July 2016 06:45 Go to previous messageGo to next message
sanjay_mishra
Messages: 2
Registered: July 2016
Location: Kolkata
Junior Member

Thanks ! I got this 13 y ago issue today..Resolved and shared it .
Re: Input truncated to 1 characters [message #653613 is a reply to message #653612] Tue, 12 July 2016 07:43 Go to previous message
Michel Cadot
Messages: 65256
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You want to share a solution that has been given 13 years ago?
I addition, the question (and the solution) is no more valid since many Oracle versions.

Previous Topic: End user query tools
Next Topic: ora-28040 no matching authentication protocol
Goto Forum:
  


Current Time: Mon Dec 18 01:26:14 CST 2017

Total time taken to generate the page: 0.06469 seconds