The following correct code is flagged as having syntax errors in the Editor in 12.9, but is fine in 12.8 and below. When executed error "ORA-00900: invalid SQL statement" occurs:
WITH PROMPTS AS
(
SELECT
1 ONE,
2 TWO,
3 THREE
FROM
DUAL
...
A new option has been introduced in 12.9:
View | Toad Options | Execute/Compile | 'Treat blank line as statement terminator', which is checked, by default. For the above code, the blank line after the first bracket is being treated as a statement terminator.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center