I think I have seen this in all the versions of Toad 14 I have run. I have never had the problem in a lower version. I was running 14.1.120.923 when this happened. I copied a working query from an open file, opened another editor tab, pasted the code in and ran it. It threw an error that the last i…

Hi @dirkt sorry for the delayed response. I turned on spool SQL (Main Menu -> Database -> Spool to Screen) to try to reproduce this but it worked OK for me. At least I guess it was working OK - Toad was sending the complete query to Oracle but of course I got a "Table or view does not exist" erro…

Here is the spool SQL output, which I guess is what you would expect: ---------------------------------- -- Session: OBI_READ@BISERVER -- Timestamp: 06:11:27.698 select s.step_name, d.name, d.type_cd, d.sucess_rows, d.start_ts, d.end_ts, d.end_ts - d.start_ts dur_d, (d.end_ts - d.start_ts) * 86400…

I copied a working query from an open file, Does this mean you copied/pasted from one tab in the editor to another? or something else?

In the original case I had copied the single statement from an open tab with a file holding multiple statements into a new tab and had the problem. To generate the spool output I copied the SQL I had posted from this page into a new tab and reproduced the problem.

Ok. I tried pasting your SQL into one editor tab, then copy/paste from one to tab to a new tab, but still it worked ok for me. Maybe it is related to some setting. Will you zip up and send me your user files folder? Instructions on how to do that, as well as my email address are here . Also, p…

It's due to the leading tab. See also TOAD 13/14 - Leading tabs in the editor truncate the sql statement by 3 characters

Thanks John. I’ll check out the beta.

Toad 14 Editor loses a character

Toad for Oracle & DevOps Toolkit

JohnDorlon July 20, 2021, 12:33pm 8

This will be fixed in the next Toad beta. If you are on 14.2, you can get the current beta here. The beta with this fix for this will come out on July 26th.

Topic		Replies	Views
TOAD 13/14 - Leading tabs in the editor truncate the sql statement by 3 characters Toad for Oracle & DevOps Toolkit	5	1341	July 20, 2021
ORA-00904: "TYPE": invalid identifier_2 Toad for Oracle & DevOps Toolkit	12	1684	October 18, 2023
Copy in query and running with F9 (ctrl-enter) stops before end Toad for Oracle & DevOps Toolkit	0	947	August 20, 2019
Toad editor stuck when executing ;;; Toad for Oracle & DevOps Toolkit	4	1908	August 16, 2016
toad 12.1.022 editor formatting problem Toad for Oracle & DevOps Toolkit	5	1006	February 20, 2014

Toad 14 Editor loses a character

Related topics