HOWTO: Remove "Rows will be truncated" msg

I am selecting from a table with big columns (eg varchar2(2000)).

When there are no recs retrieved, SQL*Plus will echo "Rows will be truncated".

How can I remove that?

Thankyou!
Judy_MAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jyhuangConnect With a Mentor Commented:
try "set termout off" if you run from a script file.
0
 
olkaCommented:
try "set feedback off"
olka
0
 
jacorbCommented:
you can use 'set long 2000' before selecting from the table.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
wren2000Commented:
If you are running from a script, I have found that additional blank lines at the end of the script will cause this message. You might try to edit your script and ensure that there are no blank lines at the end of the script.

Good Luck!
Karen.
0
 
Judy_MAuthor Commented:
olka,jacorb,wren2000, thanks for replying.

Set feedback off didn't work.
set long 2000 didn't work.
Keeping file with no trailing blanks didn't work.
0
 
ddaCommented:
What OS are you running SQL*Plus?
What is the Oracle version?
What exactly does it say?
Post "show all" output here (at sqlplus prompt type "show all")
0
 
Judy_MAuthor Commented:
Thanks for the proposal.

But I solved the prob using dda's hint to show all. After set wrap on, the mesg was gone :)
0
 
hemant KhandareCommented:
Thanks for comments .

I was also stuck dud to this but got resolved after addition of  "set wrap on"  statement in code.

thanks a lot.

Hemant
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.