SQLPLUS format [message #372070] |
Mon, 08 January 2001 18:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|