Home » RDBMS Server » Server Administration » input truncated to character 1
input truncated to character 1 [message #371176] Wed, 13 September 2000 02:19 Go to next message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
When I execute a pl/sql at sql prompt I get a message :
input truncated to 1 character.
What does this mean. My code works fine.

Thanx.
Re: input truncated to character 1 [message #371189 is a reply to message #371176] Wed, 13 September 2000 10:21 Go to previous messageGo to next message
LB
Messages: 13
Registered: September 2000
Junior Member
It's not anything to worry about...it happens occasionally for no reason I've ever figured out!! I think it has to do with where your run character is placed at the end of your script file.
Re: input truncated to character 1 [message #371194 is a reply to message #371176] Thu, 14 September 2000 01:12 Go to previous messageGo to next message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
it happens occasionally. That I also know friend, that is why I have put this question, so I want the perfect answer. I dont find it any where in books.

Thanx
Re: input truncated to character 1 [message #371199 is a reply to message #371176] Thu, 14 September 2000 06:49 Go to previous message
Marcus Fernando
Messages: 34
Registered: September 2000
Member
It happens in SQL Plus when you run a script from a file using @path\file.sql, for example.
It's not an error. To stop this, put a carriage return character at the end of file, just hit the "Enter" button and save the file.
Previous Topic: News for those who wants to learn oracle.
Next Topic: Finding the top 20 values
Goto Forum:
  


Current Time: Fri Mar 29 05:31:31 CDT 2024