DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: "Input truncated to 9 characters"

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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


  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    what he said, hit return after the last line in the file you are running as a sql script and save the changes
    I'm stmontgo and I approve of this message

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width