-
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!!)
e.g.
spool filename.lst
SELECT ....
FROM ....
WHERE ....
/
spool off
-
PROBLEM DESCRIPTION:
=====================
You are trying to compile a stored procedure and you get the warning. "Input truncated to (number) characters." The procedure compiles and runs fine.
SOLUTION DESCRIPTION:
=====================
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.
-
what he said, hit return after the last line in the file you are running as a sql script and save the changes