Solved

HOWTO: Remove "Rows will be truncated" msg

Posted on 2000-04-24
8
8,662 Views
Last Modified: 2016-09-02
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!
0
Comment
Question by:Judy_M
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 

Expert Comment

by:olka
ID: 2746326
try "set feedback off"
olka
0
 

Expert Comment

by:jacorb
ID: 2746411
you can use 'set long 2000' before selecting from the table.
0
 

Expert Comment

by:wren2000
ID: 2747317
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:Judy_M
ID: 2748253
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
 
LVL 4

Expert Comment

by:dda
ID: 2748872
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
 
LVL 1

Accepted Solution

by:
jyhuang earned 50 total points
ID: 2749267
try "set termout off" if you run from a script file.
0
 

Author Comment

by:Judy_M
ID: 2749649
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
 

Expert Comment

by:hemant Khandare
ID: 41781357
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question