Judy_M
asked on
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!
When there are no recs retrieved, SQL*Plus will echo "Rows will be truncated".
How can I remove that?
Thankyou!
you can use 'set long 2000' before selecting from the table.
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.
Good Luck!
Karen.
ASKER
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.
Set feedback off didn't work.
set long 2000 didn't work.
Keeping file with no trailing blanks didn't work.
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")
What is the Oracle version?
What exactly does it say?
Post "show all" output here (at sqlplus prompt type "show all")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the proposal.
But I solved the prob using dda's hint to show all. After set wrap on, the mesg was gone :)
But I solved the prob using dda's hint to show all. After set wrap on, the mesg was gone :)
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
I was also stuck dud to this but got resolved after addition of "set wrap on" statement in code.
thanks a lot.
Hemant
olka