OraFAQ Forum: Client Tools » Input truncated to 1 characters

Home » SQL & PL/SQL » Client Tools » Input truncated to 1 characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Input truncated to 1 characters [message #39795]

Mon, 12 August 2002 05:50

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

Report message to a moderator

Re: Input truncated to 1 characters [message #39796 is a reply to message #39795]

Mon, 12 August 2002 06:00

Mahesh Rajendran
Messages: 10694
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

Report message to a moderator

Re: Input truncated to 1 characters [message #39799 is a reply to message #39795]

Mon, 12 August 2002 07:57

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.

Report message to a moderator

Re: Input truncated to 1 characters [message #41768 is a reply to message #39795]

Thu, 30 January 2003 09:49

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.

Report message to a moderator

Re: Input truncated to 1 characters [message #653609 is a reply to message #39795]

Tue, 12 July 2016 06:14

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 .

Report message to a moderator

Re: Input truncated to 1 characters [message #653611 is a reply to message #653609]

Tue, 12 July 2016 06:36

John Watson
Messages: 8461
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

Report message to a moderator

Re: Input truncated to 1 characters [message #653612 is a reply to message #653611]

Tue, 12 July 2016 06:45

sanjay_mishra
Messages: 2
Registered: July 2016
Location: Kolkata

Junior Member

Thanks ! I got this 13 y ago issue today..Resolved and shared it .

Report message to a moderator

Re: Input truncated to 1 characters [message #653613 is a reply to message #653612]

Tue, 12 July 2016 07:43

Michel Cadot
Messages: 67667
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 27 21:02:22 CST 2021