I've a .SQL report I run. It spools to a filename, does the SELECT ... then spools off.
It always ends with "Input truncated to 9 characters"
What is this? Is it something to do with the 'spool off' command (which is 9 chars long!!)
10-16-2002, 11:59 AM
You are trying to compile a stored procedure and you get the warning. "Input truncated to (number) characters." The procedure compiles and runs fine.
This is caused by not having a carriage return after the last line in the procedure. If the last line is "/", then the message returned would be: "Input truncated to 1 characters." If the last line is "show errors", then the message returned would be: "Input truncated to 11 characters." The same can happen from a SQL*Plus script as well as from a stored procedure if there is no carriage return at the end of the line.
10-16-2002, 07:55 PM
what he said, hit return after the last line in the file you are running as a sql script and save the changes