Return
-
Title
Errors messages in 13.1 that don't appear in 12.11 -
Description
Invalid identifier quoted string not properly identified.
Toad 13.1 will throw the following error: "ORA-00904: "SRC"."TYPE_:" invalid identifier". This SQL completes as expected when run in Toad v12.11, if the exact same steps are followed.For some reason, it appears that it's not reading in the "code" portion of the "src.type_code" identifier, the last bit of text at the very end of the SQL code.If the SQL is selected/highlighted and the shortcut is used, then the script will execute successfully. The SQL will also execute correctly if either the "Execute/compile as statement at caret" or "Execute as script" buttons are used. -
Resolution
Replicated and make a change to a space in the code.Note: I took the space before the CREATE and space "temp2 ( " on the table creation code.CREATE TABLE temp2 (RE_COMPL_DATE DATE,RE_COMPL_RSN VARCHAR2(3 BYTE));############merge into temp2using (select 'AA' type_code,to_date('12/01/9999') event_datefrom dual) srcon ( 1 = 1 )when matched then updateset temp2.re_compl_date = src.event_date,temp2.re_compl_rsn = src.type_code;The modified code runs successfully and does not produce the same error as the original code. But looks like the culprit is related to the "Tab/Indent" encoded characters. This is also why seeing modifications work in some cases and not in others, based on your changed spacing.In Notepad++, using the original code the tab-indent...../..../.. set temp2.re_compl_date = src.event_date,.../.. temp2.re_compl_rsn = src.type_code;If the tab indents are replaced with spaces characters, the code works perfectly in Toad 13.1. However, if more Tab-indenting is added, then the error thrown by Toad cuts off even more characters from the end of the SQL script. Characters cutoff from the end of the script seem to range between 2 and 4 characters additional missing characters, PER each tab-indent added.Toad 12.11 does not show any problems with parsing the tab-indent encoded characters. In contrast, Toad 13.1 appears to not be able to parse the encoded tab-indent characters correctly.This issue will be fixed in a future version of the product. Debug ID TOR-3315 -
Defect ID
TOR-3315