When I do a DESC joe in TOAD against an Oracle database, the following is returned:
When I am signed on to the same Oracle database as the same user and do a DESC joe with SQL Developer, the following is correctly returned:
I have reinstalled TOAD twice and have the tested the DESC commands across multiple databases and the returning results for VARCHAR2 datatypes with TOAD is consistently incorrect and consistently multiplied by factor of 4.
We are running Oracle 122r2 on the server. I am using Toad 12.10 (reinstalled), but the original problem occurred in Toad 13.1. I thought trying a different version of Toad would rectify the problem. It did not.
Screen prints attached.
If you would please send the syntax to do a spool file in Toad, that would be great. I know how to do it with SQl Plus, but am new to Toad.
(Attachment screen prints for john.docx is missing)
If you typed in "DESC [tablename]" and pressed F5 in the editor and received this incorrect result, this issue was recently identified and was actually just fixed. It should be in the beta that will be released today. If you get a chance, make sure you have Toad 13.1 installed and download the Toad for Oracle beta from here this afternoon:
That should fix the issue you're seeing. Please feel free to let us know if this does not solve the issue you're seeing and we'll continue to look further.