Input truncated to 9 characters 1

[dps]

Can someone help in alleviating this problem?

 

[johnherman]

Expand the target column size?

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[SantaMufasa]

Yes, DPS, we can help. You have encountered the most imperceptible and esoteric diagnostic in all of Oracle. This is a SQL*Plus diagnostic, not SQL. It comes when you execute a script in SQL*Plus and you forget to hit a [Return] at the end of your last line of script code.

To illustrate the problem, bring up your script in your favourite text editor, then move your mouse on the screen to well below your last line of visible text, then click your mouse button. You will see the cursor jump up to the right-hand end of your last line of text. (BTW, your last line of text is 9 characters long, right?) Just hit the [Enter] key so that your cursor drops to the next line and is flashing in column 1 of the line just beyond your last visible line of code.

Re-run your script, and the diagnostic will be gone.

Let us know of your success.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[dps]

SantaMusa - YOU'e a Genius!!

I could not get any clear direction at all via GOOGLE; with people giving all sorts of remedies.

By jo it's done it!!!

 

[KenCunningham]

That's always intrigued me too Dave. Thanks for clearing it up.