Solved

HOWTO: Remove "Rows will be truncated" msg

Posted on 2000-04-24
8
7,746 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
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

816 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now