I have Toad for Oracle 12.1 and my install has a flaw in that I can only retrieve a maximum of 1143 characters per cell when I execute a query. I have had two other users execute the exact same query and they retrieve the full results as do I when I use SQL Developer to run the query. I was originally limited to 215 characters but I un-installed and re-installed the software. Now it limits me to 1143 characters on re-install.
I know the limit because when I export the data to excel and verify that everything in Toad has transferred to Excel and then do a length function on the cells, the largest is 1143 and there are several of them.
Does anyone have a suggestion on how to resolve the issue? I have reviewed all of the preferences/options and have not had any luck with making the size unlimited. Some of the retrievals I execute will exceed 30,000 characters.