Return
-
Title
Data not displaying in Toad editor. -
Description
When I do a query in Editor I dont get data back. I run with both F5(Execute as SQL) and F9(Execute as Statement) and I dont get any results. The columns and rows do show up, there is just no data in the fields.
If I run it in SQL Plus I do get results displayed. -
Cause
It is not possible to get more than 4000 characters in a varchar2(4000) field. Line breaks count as characters. The problem might be that there are too many end-of-data characaters in the data and is making the info too large to show. -
Resolution
There are a numberof end-of-data characaters within your data. If you use the REPLACE function to hide them, then you can see the data:select replace(CN_QUESTION_OR_TXT, chr(0), )
from somedb.test_small_tableToreplace the end-of-data characters with line breaks:
select replace(CN_QUESTION_OR_TXT, chr(0), chr(10))
from somedb.test_small_tableThis will give you an indication of the number of end-of-data characters within the data.