SQL using Oracle SQL*Plus

Input truncated to <n> characters

Input truncated to <n> characters  is an annoying message.

I have used  <n> because the number of characters nominated in the message varies.   n  is the number of characters in the last non-blank line in your file.
Input truncated to 1 characters  is a common version - usually because you have  /  as the last non-blank line in your file.
Input truncated to 10 characters  is a common version - usually because you have  TTITLE OFF  as the last non-blank line in your file.

I get rid of this message by always putting an end-of-line character at the end of my code - that is, by hitting [Enter] so that the cursor is at the beginning of a new line.

If adding an end-of-line (EOL) to your file doesn't seem to work for you, check:

• Have you saved your file before starting it again?

• Are you starting the new file and not the file in your buffer?

• Are you in the correct working directory?
  ie  Are you starting the version of the file you have just changed, or a version with the same name in a different directory?

• If the problem persists, try this:

  1. Change the name of the file   mv qn.sql qnold.sql
  2. Open a new file  qn.sql
  3. Copy from  qnold.sql, and paste into  qn.sql,
     from the top of the file to the first blank line.

[Top]