Home » RDBMS Server » Server Administration » SQLPLUS format
SQLPLUS format [message #372070] Mon, 08 January 2001 18:06 Go to next message
BadriNarayan
Messages: 1
Registered: January 2001
Junior Member
Hi,

I have to store the results of a query in a text file. Hence I have a sql file setting the various parameters
such as LINESPACE, TRIMOUT (set to off) etc. However when I run the script I get the error "Input Truncated to 9 characters" I have set the LINESPACE to be sufficiently large (larger than the record length), but I still get this error and it is driving me nuts.
Anybody please help!!!
Re: SQLPLUS format [message #372085 is a reply to message #372070] Tue, 09 January 2001 10:07 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,

In the sql file add a empty line at bottom...

There should be an empty line at the bottom to avoid that error
"Input Truncated to X characters"

Bala
Previous Topic: Need some special output from select (order, decode, ...)
Next Topic: How to put a '&' in the SQL query?
Goto Forum:
  


Current Time: Sat May 18 07:09:53 CDT 2024