Toad World® Forums

Formatting: collate error

Hi,

The Toad code formatter in Toad for Oracle 13.3 is producing an error when the SQL statement contains COLLATE.

Simple example:
SELECT *
FROM all_procedures
WHERE object_name LIKE '%proc%' COLLATE BINARY_AI;

De statement runs fine.
When formatting the code, an error is raised:
[Error] Syntax check (3: 34): ERROR: line 3, column 34, ending line 3, column 40:
Found 'COLLATE': Expecting: end-of-input -or- FETCH FOR OFFSET ORDER -or- INTERSECT MINUS UNION -or- CONNECT GROUP HAVING MODEL START -or- OR -or- AND -or- ESCAPE -or- + - | || -or- * / MOD REMAINDER -or- ** -or- ( (+) AT DAY MULTISET YEAR

Hi Peter,
FYI The latest formatter for Toad 13.3 was released on Feb 17, 2020 (QP5 v360) and features this error. It was fixed on Feb 5, 2021 (QP5 v364).
I leave it up to the Toad team to add any suggestions.
Hope this info can help.
Andre

I don't think there is anything you can do to make Toad 13.3 format this statement correctly.

You'll have to update to Toad version 14.2 if you want it fixed. And version 15.0 will be out within the next month or so.

-John